{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Master Data","Extra Ded. ","GA55 ","COMPUTATION","Form No. 16"],"not_rendered":{"images":9,"external_links":2,"defined_names":11,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"merged":[[2,1,2,2],[3,1,5,1],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[12,1,12,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[20,2,21,2]]}
[null,null,"Instructions"]
[]
[null,";g ,Dly izksxzke esjs ije~ iwT; xq:nso Jh Jh 1008 oklqnso th egkjkt o esjs bZ\"V izHkq t;  ctjaxcyh o ikcwth egkjkt dks lefiZr gSaA esjs ekrk & firk o xq:tuksa ds vk'khokZn ls ;g izksxzke e/;izns'k jkT; ds lHkh foHkkx ds dkfeZdksa dh lsok esa lknj izLrqr gSaA"]
[null,null,"How to use this Programme"]
[null,null,"If you have Hindi font problem, then first you should install Hindi font KRUTI DEV 010  in your computer."]
[null,null,"lcls igys vki jktLFkku lHkh 'kSf{kd osclkbZV ij ,Dly xq: ghjkyky tkV }kjk fufeZr vk;dj x.kuk ,Dly ,Iyhds'ku 2020&21 ds viMsV otZu+ dks MkmuyksM djsasaA blds vykok vki Google ij Heeralal Jat fy[kdj lpZ djsaxs rks Hkh vkidks ist fey tk;sxkA tgka ls vki ;g izksxzke MkmuyksM dj ldrs gSaA mlds ckn ftrusa dkfeZdksa dh vk;dj x.kuk djuh gS] mruh gh ,Dly izksxzke 'khV dks muds uke ls vyx vyx Qkby esa  Save  dj ysosaA izR;sad dkfeZd ds fy, ds fy, ,d QkbZy dks mi;ksx esa ysosaA "]
[null,"t; xq:nso ","vki bl ,Dly izksxzke ij dk;Z djus ls igys bUde VSDl foHkkx ds u;s :Yl o fu;e bUde VSDl foHkkx dh website vFkok ys[kk foK vDVqcj 2020 dkss t:j i<+sA oSls bl ,Dly izksxzke esa iq.kZ lko/kkuh cjrh xbZ gSa] fQj Hkh foHkkx ds fu;e gh loksZijh o fljks/kk;Z gSaA"]
[null,"Most Doable Work",null,"ije~ iwT; xq:nso"]
[null,"vki bl ,Dly izksxzke esa nksa 'khVksa ekLVj MkVk 'khV o ,DLV~zk fMMsD'ku 'khV dks lko/kkuhiwoZd vuykWd lsy tks lQsn dyj esa gSa] dks Hkjuk ¼MkVk fQfyax½ gSaA vkxs dh 'khVs vkWVksa tujsV gSaA os lHkh ykWd gSaA ogk ij vkidks dqN ugh djuk gSaA flQZ A4 lkbZt esa fizUV fudkyuk gSa vkSj ist Hkh lsV fd;k gqvk gSaA"]
[]
[null,"Only Put Here Curser","                            यदि आपको आयकर की नयी व विद्यमान कर स्लैब देखनी हो तो क्रसर को सामने की सेल पर ले जाइये।  ","new update on 01-12-2020 \nnew updated related you tube video link"]
[]
[null,";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",null,"https://youtu.be/FwBqjLiBd28"]
[]
[null,"This Programme Developed by:        HEERALAL JAT "]
[null,"Senior Teacher"]
[null,"Mahatma Gandhi Government School (English Medium) BAR , PALI"]
[null,"heeralaljatchandawal@gmail.com"]
[null,"V./P. - Chandawal Nagar, Teh.- sojat city, Dist.- Pali (Raj) 306306"]
[]
[null,null,"Watch the You Tube Video For More Information."]
[]
[]
[null,null,"https://www.youtube.com/playlist?list=PLmNJTudmvkgL-ZI7qFKfQ6oz6WTNnW31z"]
[]
[null,null,"You Tube Channel"]
[]
[null,null,"https://www.youtube.com/c/Heeralaljat/"]

{"sheet":"Master Data","index":1,"n_rows":36,"n_cols":30,"rows_kept":36,"merged":[[1,1,1,3],[1,4,1,7],[3,1,3,2],[3,3,3,8],[3,10,3,13],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,10,11,13],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[17,1,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,10,17,13],[19,4,19,7],[22,1,22,3],[22,5,22,7],[24,1,24,3],[24,5,24,7],[28,2,28,10],[29,5,29,7]]}
[{"$nulls":28},1,"2020-04-01"]
[null,"https://www.youtube.com/watch?v=kSG6hPX7VSQ",null,null,"EMPLOYEE  PERSONAL  DETAIL",{"$nulls":14},"JUN",20,{"$nulls":5},"2019-08-01",null,2,"2020-05-01"]
[{"$nulls":28},3,"2020-06-01"]
[null,"Office Name :-",null,"PRINCIPAL, H.S.S.Girls PICHHORE (3932003025) M.P.\n",{"$nulls":15},"JUL",{"$nulls":3},1000,null,null,"2019-09-01",null,4,"2020-07-01"]
[{"$nulls":28},5,"2020-08-01"]
[null,"Employee Name :-",null,"Heeralal jat",null,"Designation :-",null,"Middle Teacher",{"$nulls":11},"AUG",{"$nulls":3},620,null,null,"2019-10-01",null,6,"2020-09-01"]
[{"$nulls":28},7,"2020-10-01"]
[null,"School Name :-","Posting Place :-","GHS HARIJAN BASTI PICHHORE ",null,"DDO Name :-",null,"B.E.O.PICHHOR",{"$nulls":11},"SEP",{"$nulls":6},"2019-11-01",null,8,"2020-11-01"]
[{"$nulls":28},9,"2020-12-01"]
[null,"Employee Unique Code :-",null,390263384,null,"UID AADHAR No. :-",null,{"v":123465471475,"d":"1234 6547 1475 "},{"$nulls":11},"OCT",{"$nulls":6},"2019-12-01",null,10,"2021-01-01"]
[{"$nulls":28},11,"2021-02-01"]
[null,"PAN No. :-",null,"abcde1234h",null,"TAN NO. :-",{"$nulls":13},"NOV",{"$nulls":6},"2020-01-01",null,12]
[]
[null,"GPF No. :-",null,11,null,"SI No. :-",null,123456,{"$nulls":11},"DEC",{"$nulls":6},"2020-02-01"]
[]
[null,"PRAN No. :-",null,110161963331,null,"Bank A/C No. :-",null,121212121212121]
[]
[null,"Age Group :- ",null,"Under 60",null,"Treasury Location :-",null,"Picchor Sub Treasury",null,null,"ije~ iwT; xw:nso Jh Jh 1008 oklwnso th egkjkt",{"$nulls":7},"YES","Under 60",8,"GPF","Jaipur (U.A.)",null,"Regular Pay"]
[{"$nulls":18},"NO","Above 60",9,"NPS","Ajmer",null,"Fix Pay"]
[{"$nulls":4},"EMPLOYEE  PAY  DETAIL",{"$nulls":14},"Above 80"]
[]
[]
[null,"foadykax HkÙkk %&","foadykax HkÙkk %&",null,0,"  vkidks osru fey jgk gS %&",null,null,"Regular Pay"]
[]
[null,"    7th PAY  HRA izfr'kr esa %&",null,null,8,"%                            GPF / NPS :- ",null,null,"NPS",{"$nulls":17},"JAN","2020-03-01"]
[{"$nulls":26},"FEB","2020-04-01"]
[{"$nulls":26},"MAR","2020-05-01"]
[{"$nulls":26},"APR","2020-06-01"]
[null,null,"First Unlock Cell Entry Fill Up Then Click On Go to Next Sheet Button",{"$nulls":23},"MAY","2020-07-01"]
[{"$nulls":5},"Use  Button For going to Next Sheet H",{"$nulls":20},"JUN","2020-08-01"]
[{"$nulls":26},"JUL","2020-09-01"]
[{"$nulls":26},"AUG","2020-10-01"]
[{"$nulls":26},"SEP","2020-11-01"]
[{"$nulls":26},"OCT","2020-12-01"]
[{"$nulls":26},"NOV","2021-01-01"]
[{"$nulls":26},"DEC","2021-02-01"]

{"sheet":"Extra Ded. ","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"merged":[[0,0,0,2],[1,1,1,2],[2,2,2,8],[5,2,5,3],[5,5,23,5],[5,6,5,7],[5,9,23,9],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,2,8,3],[8,6,8,7],[9,2,9,3],[9,6,9,7],[10,2,10,3],[10,6,10,7],[11,2,11,3],[11,6,11,7],[12,2,12,3],[12,6,12,7],[13,2,13,3],[13,6,13,7],[14,2,14,3],[14,6,14,7],[15,2,15,3],[15,6,15,7],[16,2,16,3],[16,6,16,7],[17,2,17,3],[17,6,17,7],[18,2,18,3],[18,6,18,7],[19,2,19,3],[19,6,19,7],[20,2,20,3],[20,6,20,7],[21,2,21,3],[21,6,21,7],[22,2,22,3],[22,6,22,7],[23,2,23,3],[23,6,23,7],[24,2,24,8]]}
["https://www.youtube.com/watch?v=NWwIhkhEUoc"]
[null,"अधिक जानकारी के लिए ऊपर Youtube video का लिंक दिया गया है। "]
[null,null,"osru dVkSrh ds vfrfjDr dVkSfr;k ftlds rgr vki vk;dj esa NwV pkgrs gSa] rFkk vfrfjDr ¼vU;½ vk; dks ;gkW ij bUnzkt djsA"]
[]
[]
[null,null,"1- edku fdjk;k HkRrk ¼;fn jlhn ds ek/;e ls NwV ysuh gS rks ;gkW fy[ksa½",{"$nulls":3},"20- bfDoVh fyad lsfoax Ldhe"]
[null,null,"2- LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",null,50000,null,"21- x`g fdjk;k] /kkjk 10¼13-A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA "]
[null,null,"3- euksjatu Hkrk /kkjk 16 (ii) ds vUrxZr ",{"$nulls":3},"22- LFkfxr okf\"kZdh ¼Defferred Annuty)"]
[null,null,"4- O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",{"$nulls":3},"23- osru ds vykok tek djk;k x;k aavk;dj (TDS)"]
[null,null,"5- x`g lEifr ls izkIr fdjk;k & vk;",{"$nulls":3},"24- vU; vk; ¼/kkjk 80 lh ds vUrxZr½ "]
[null,null,"6- x`gdj ",{"$nulls":3},"25- vU; dksbZ Hkh izdkj NqV feyrh gSa tks /kkjk 10¼13&,½ o 10¼13½ds vUrxZr vkrh gks rks ;gk fy[ks ,oa vU; dj eqDr HkRrk ;gkW fy[ksaA"]
[null,null,"7- x`g _.k dh ewy fdLr ;gkW fy[kuh gSaA tks NwV ysuh gSaA",{"$nulls":3},"26- /kkjk 80CCC - isa'ku Iyku gsrq va'knku"]
[null,null,"8- x`g _.k fdLr ij C;kt tks NwV ysuk gS] ;gkW fy[ksA",{"$nulls":3},"27- vU; tek jkf'k ¼/kkjk 80 lh ds vUrxZr½ o E;qpvy QaM"]
[null,null,"9- thou chek izhfe;e  LIC",{"$nulls":3},"28- /kkjk 80CCD(1B) -uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000½",null,50000]
[null,null,"10- ih-,y-vkbZ- (PLI)",{"$nulls":3},"29- /kkjk 80D - fpfdRlk chek izhfe;e "]
[null,null,"11- V;w'ku Qhl (Tution Fees)",{"$nulls":3},"30- /kkjk 80DD - fodykax vkfJrksa ds fpfdRlk mipkj "]
[null,null,"12- ;w- ,y- vkbZ- ih-@okf\"kZd Iyku",{"$nulls":3},"31- /kkjk 80DDB - fof'k\"V jksxksa ds mipkj gsrq dVkSrh ¼vf/kdre 40000 :½"]
[null,null,"13- jk\"Vªh; cpr i= (NSC)",{"$nulls":3},"32- /kkjk 80E - mPp f'k{kk gsrq fy, _.k dk C;kt ¼/kkjk 80E½"]
[null,null,"14- jk\"Vªh; cpr i= ij vnr C;kt",{"$nulls":3},"33- /kkjk 80G - /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼d Js.kh 100% ,oa [k Js.kh 50%½"]
[null,null,"15- yksd Hkfo\"; fuf/k (PPF)",{"$nulls":3},"34- /kkjk 80U - LFkkbZ :i ls 'kkjhfjd vleFkZrrk "]
[null,null,"16- jk\"Vªh; cpr Ldhe (NSS)",{"$nulls":3},"35- /kkjk 80TTA - cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)",null,1000]
[null,null,"17- lqdU;k le`f) ;kstuk (SSY)",{"$nulls":3},"36- /kkjk 80 GGA - vuqeksfnr oSKkfud]lkekftd]xzkeh.k fodkl vkfn gsrq fn;k x;k nku"]
[null,null,"18-  Bonds ls C;kt",{"$nulls":3},"37-   ,QMh vkfn vU; tek jkf'k ij izkIr dqy C;kt ¼ihih,Q dks NksM+dj½"]
[null,null,"19- vU; vk;  %",{"$nulls":3},"38- jkgr /kkjk 89 ds rgr ¼ vxj NwV ysuh gS rks ;gkW fy[ksA½",null,0]

{"sheet":"GA55 ","index":3,"n_rows":30,"n_cols":29,"rows_kept":30,"merged":[[0,1,0,25],[0,26,0,28],[1,0,1,2],[1,3,1,7],[1,8,1,11],[1,12,1,15],[1,16,1,19],[1,20,1,26],[1,27,1,28],[2,0,2,1],[2,2,2,4],[2,6,2,8],[2,10,2,13],[2,14,2,16],[2,17,2,21],[2,22,2,25],[2,26,2,28],[3,0,3,12],[3,13,3,25],[3,26,4,26],[3,27,4,27],[3,28,4,28],[28,2,28,7],[28,18,28,26],[29,2,29,7],[29,18,29,26]]}
[null,{"$f":"IF(AND('Master Data'!D4=\"\"),\"\",CONCATENATE(\"Office Name :- \",PROPER('Master Data'!D4)))","v":"Office Name :- Principal, H.S.S.Girls Pichhore (3932003025) M.P.\n"}]
["Employee Name :-",null,null,{"$f":"UPPER(IF('Master Data'!D6=\"\",\"\",'Master Data'!D6))","v":"HEERALAL JAT"},{"$nulls":4},"Designation :-",{"$nulls":3},{"$f":"UPPER(IF('Master Data'!H6=\"\",\"\",'Master Data'!H6))","v":"MIDDLE TEACHER"},{"$nulls":3},"Posting Place :-",{"$nulls":3},{"$f":"UPPER(IF('Master Data'!D8=\"\",\"\",'Master Data'!D8))","v":"GHS HARIJAN BASTI PICHHORE "},{"$nulls":6},"osru Mªk ekufp="]
["PAN No. :-",null,{"$f":"UPPER(IF('Master Data'!D12=\"\",\"\",'Master Data'!D12))","v":"ABCDE1234H"},null,null,"E. ID",{"$f":"IF(AND('Master Data'!D10=\"\"),\"\",'Master Data'!D10)","v":390263384},null,null,"GPF",{"$f":"IF(AND('Master Data'!D14=\"\"),\"\",'Master Data'!D14)","v":11},{"$nulls":3},"PRAN No. :-",null,null,{"$f":"IF(AND('Master Data'!D16=\"\"),\"\",'Master Data'!D16)","v":110161963331},{"$nulls":4},"Bank A/C.",{"$nulls":3},{"$f":"IF(AND('Master Data'!H16=\"\"),\"\",'Master Data'!H16)","v":121212121212121}]
["Details of Payment",{"$nulls":12},"Details of Deduction\n",{"$nulls":12}," Net   Salary ","Voucher N0.","Voucher Date "]
["S.N.","Month","Basic  Pay","Dearness Pay\n","DA "," Conv. All. For. Phy. Cha/\nConv. All. ","HRA","CCA","Interim Relief","Other\nPaymen"," PP on pay"," Fixed T.A./\nSumptuary All. "," Gross Salary","S.I.","GPF","NPS","GIS\n","Recovery"," Relief Fund "," Income Tax/\nProfess.Tax/\nFBF "," GIS  (All India) "," HRR "," Court Deduction ","Other"," Other AG Deduction "," Total Deduction"]
[1,"2020-03-01",35800,null,1234,null,398,200,{"$nulls":4},{"$f":"IF(AND(B6=\"\"),\"\",SUM(C6:L6))","v":37632},null,null,{"$f":"IF(AND('GA55 '!$B6=\"\"),\"\",ROUND((C6+D6+E6)*0.1,0))","v":3703},200,null,1000,208,{"$nulls":5},{"$f":"IF(AND(B6=\"\",M6=\"\"),\"\",SUM(N6:Y6))","v":5111},{"$f":"IF(AND(Z6=\"\",M6=\"\"),\"\",SUM(M6-Z6))","v":32521}]
[2,"2020-04-01",{"$f":"IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!L$6))","v":0},{"$f":"IF(AND(B7=\"\"),\"\",SUM(C7:L7))","v":37632},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B7=\"\"),\"\",ROUND((C7+D7+E7)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B7=\"\"),\"\",'GA55 '!Y$6))","v":0},{"$f":"IF(AND(B7=\"\",M7=\"\"),\"\",SUM(N7:Y7))","v":5111},{"$f":"IF(AND(Z7=\"\",M7=\"\"),\"\",SUM(M7-Z7))","v":32521}]
[3,"2020-05-01",{"$f":"IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!L$6))","v":0},{"$f":"IF(AND(B8=\"\"),\"\",SUM(C8:L8))","v":37632},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B8=\"\"),\"\",ROUND((C8+D8+E8)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B8=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[4,"2020-06-01",{"$f":"IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B9=\"\"),\"\",ROUND((C9+D9+E9)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B9=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[5,"2020-07-01",{"$f":"IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B10=\"\"),\"\",ROUND((C10+D10+E10)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B10=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[6,"2020-08-01",{"$f":"IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B11=\"\"),\"\",ROUND((C11+D11+E11)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B11=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[7,"2020-09-01",{"$f":"IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B12=\"\"),\"\",ROUND((C12+D12+E12)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B12=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[8,"2020-10-01",{"$f":"IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B13=\"\"),\"\",ROUND((C13+D13+E13)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B13=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[9,"2020-11-01",{"$f":"IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B14=\"\"),\"\",ROUND((C14+D14+E14)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B14=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[10,"2020-12-01",{"$f":"IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B15=\"\"),\"\",ROUND((C15+D15+E15)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B15=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[11,"2021-01-01",{"$f":"IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B16=\"\"),\"\",ROUND((C16+D16+E16)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B16=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[12,"2021-02-01",{"$f":"IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!C$6)","v":35800},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!D$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),0,IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!E$6))","v":1234},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!F$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!G$6))","v":398},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!H$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!I$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!J$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!K$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!L$6))","v":0},37632,{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!N$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!O$6))","v":0},{"$f":"IF(AND('GA55 '!$B17=\"\"),\"\",ROUND((C17+D17+E17)*0.1,0))","v":3703},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!Q$6))","v":200},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!R$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!S$6))","v":1000},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!T$6))","v":208},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!U$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!V$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!W$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!X$6))","v":0},{"$f":"IF(AND('Master Data'!$I$23='Master Data'!$Y$19),\"\",IF(AND('GA55 '!$B17=\"\"),\"\",'GA55 '!Y$6))","v":0},5111,32521]
[13,"Bonus",{"$nulls":10},0,null,null,{"$f":"IF(AND('GA55 '!$B18=\"\"),\"\",ROUND((C18+D18+E18)*0.1,0))","v":0},{"$nulls":9},0,0]
[14,"DA Arrear jul 19 to dec 20",{"$nulls":10},0,null,null,{"$f":"IF(AND('GA55 '!$B19=\"\"),\"\",ROUND((C19+D19+E19)*0.1,0))","v":0},{"$nulls":9},0,0]
[15,"DA Arrear jan 20 to feb 20",{"$nulls":10},0,null,null,{"$f":"IF(AND('GA55 '!$B20=\"\"),\"\",ROUND((C20+D20+E20)*0.1,0))","v":0},{"$nulls":9},0,0]
[16,"PL Surrender",{"$nulls":10},0,null,null,{"$f":"IF(AND('GA55 '!$B21=\"\"),\"\",ROUND((C21+D21+E21)*0.1,0))","v":0},{"$nulls":9},0,0]
[17,"Other Arrear",{"$nulls":10},0,null,null,{"$f":"IF(AND('GA55 '!$B22=\"\"),\"\",ROUND((C22+D22+E22)*0.1,0))","v":0},{"$nulls":9},0,0]
[18,"Other ",{"$nulls":10},0,null,null,{"$f":"IF(AND('GA55 '!$B23=\"\"),\"\",ROUND((C23+D23+E23)*0.1,0))","v":0},{"$nulls":9},0,0]
[19,{"$nulls":11},"",null,null,{"$f":"IF(AND('GA55 '!$B24=\"\"),\"\",ROUND((C24+D24+E24)*0.1,0))","v":""},{"$nulls":9},"",""]
[20,{"$nulls":11},"",null,null,{"$f":"IF(AND('GA55 '!$B25=\"\"),\"\",ROUND((C25+D25+E25)*0.1,0))","v":""},{"$nulls":9},"",""]
[21,{"$nulls":11},"",null,null,{"$f":"IF(AND('GA55 '!$B26=\"\"),\"\",ROUND((C26+D26+E26)*0.1,0))","v":""},{"$nulls":9},"",""]
[null,"TOTAL F",{"$f":"IF(AND($D$2=\"\"),\"\",SUM(C6:C26))","v":429600},{"$f":"IF(AND($D$2=\"\"),\"\",SUM(D6:D26))","v":0},14808,0,4776,2400,0,0,0,0,451584,0,0,44436,2400,0,12000,2496,0,0,0,0,0,61332,390252]
[]
[null,null,{"$f":"UPPER(IF('Master Data'!D6=\"\",\"\",'Master Data'!D6))","v":"HEERALAL JAT"},{"$nulls":15},{"$f":"IF(AND('Master Data'!H8=\"\"),\"\",CONCATENATE(\"( \",UPPER('Master Data'!H8), \" )\",))","v":"( B.E.O.PICHHOR )"}]
[null,null,"Signature of Employee",{"$nulls":15},"Signature of DDO"]

{"sheet":"COMPUTATION","index":4,"n_rows":69,"n_cols":34,"rows_kept":69,"merged":[[0,0,0,14],[1,2,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,14],[2,1,2,2],[2,3,2,7],[2,9,2,11],[2,13,2,14],[3,0,4,0],[3,1,3,12],[3,17,7,21],[4,1,4,12],[5,1,5,12],[6,1,6,12],[7,0,9,0],[7,1,7,9],[7,10,7,12],[7,13,8,14],[8,1,8,9],[8,10,8,12],[9,1,9,9],[9,10,9,12],[10,1,10,12],[11,0,13,0],[11,1,11,7],[11,8,11,9],[11,10,11,12],[11,13,13,14],[12,1,13,2],[12,3,12,4],[12,5,12,7],[12,8,12,9],[12,10,12,12],[13,3,13,4],[13,5,13,7],[13,8,13,9],[13,10,13,12],[14,1,14,12],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,9,15,12],[16,1,16,3],[16,4,16,5],[16,6,16,7],[16,9,16,12],[17,1,17,12],[18,0,34,0],[18,1,18,14],[18,17,18,18],[19,1,19,14],[20,2,20,4],[20,8,20,10],[20,13,30,14],[21,2,21,4],[21,8,21,10],[21,16,23,20],[22,2,22,4],[22,8,22,10],[22,33,23,36],[23,2,23,4],[23,8,23,10],[24,2,24,4],[24,8,24,10],[25,2,25,4],[25,8,25,10],[25,16,30,18],[26,2,26,4],[26,8,26,10],[27,2,27,4],[27,8,27,10],[28,2,28,4],[28,8,28,10],[29,2,29,4],[29,8,29,10],[30,2,30,4],[30,7,30,10],[31,1,31,12],[31,18,33,18],[32,1,32,12],[33,1,33,12],[34,1,34,12],[35,0,44,0],[35,1,35,14],[36,1,36,12],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[40,17,42,21],[41,1,41,12],[42,1,42,12],[43,1,43,12],[43,17,44,18],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,0,61,0],[48,1,48,14],[48,23,48,25],[48,27,48,29],[49,1,49,4],[49,5,49,8],[49,9,49,12],[50,1,50,3],[50,5,50,7],[50,9,50,11],[51,1,51,3],[51,5,51,7],[51,9,51,11],[52,1,52,3],[52,5,52,7],[52,9,52,11],[53,1,53,3],[53,5,53,7],[53,9,53,11],[54,1,54,3],[54,5,54,7],[54,9,54,11],[54,17,56,21],[55,1,55,3],[55,5,55,7],[55,9,55,11],[56,1,56,3],[56,5,56,7],[56,9,56,11],[57,1,57,12],[58,1,58,12],[58,16,59,18],[59,1,59,12],[60,2,60,12],[61,1,61,12],[62,1,62,12],[63,1,63,12],[64,0,65,0],[64,1,65,3],[64,4,64,6],[64,7,64,8],[64,10,64,11],[64,12,64,13],[65,4,65,6],[65,7,65,8],[65,10,65,11],[65,12,65,13],[66,0,66,12],[68,11,68,13]]}
[{"$f":"IF(AND('Master Data'!D4=\"\"),\"\",CONCATENATE(\"Office Name :- \",PROPER('Master Data'!D4)))","v":"Office Name :- Principal, H.S.S.Girls Pichhore (3932003025) M.P.\n"},{"$nulls":18},2]
[null,null,"vk;dj x.kuk izi= o\"kZ &",null,null,"2020-2021",null,"¼dj fu/kkZj.k o\"kZ &",null,"2021-2022)",null,{"$f":"IF(T14=T2,\"Old Tax Regime\",\"New Tax Regime\")","v":"Old Tax Regime"},{"$nulls":7},1]
[1,"uke deZpkjh %",null,{"$f":"UPPER('Master Data'!D6)","v":"HEERALAL JAT"},{"$nulls":4}," in %",{"$f":"UPPER('Master Data'!H6)","v":"MIDDLE TEACHER"},null,null,"PAN :",{"$f":"UPPER('Master Data'!D12)","v":"ABCDE1234H"}]
[2,"vk; % o\"kZ&2020&21 esa izkIr dqy osru ¼ dj ;ksX; lqfo/kkvksa ds eqY; lfgr ½",{"$nulls":11},"#-",{"$f":"'GA55 '!M27","v":451584},null,null,"आप विद्यमान आयकर दर या नवीन आयकर दर दोनों में से किसी एक विकल्प को चुनकर आयकर गणना प्रपत्र तैयार कर सकते है।  "]
[null,"ljdkj }kjk ns; NPS dh jkf'k &",{"$nulls":11},"#-",{"$f":"IF('Master Data'!H18=\"Yes\",0,IF('Master Data'!I25='Master Data'!V19,'GA55 '!P27,0))","v":44436}]
[3,"x`g fdjk;k] /kkjk 10¼13-A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA ",{"$nulls":11},"#-",{"$f":"IF(T14=T2,SUM('Extra Ded. '!I7+'Extra Ded. '!E6+'Master Data'!E23),\"0\")","v":0},null,"E"]
[4,"                                                              'ks\"k ¼2&3½",{"$nulls":11},"#-",{"$f":"(O4+O5)-O6","v":496020}]
[5," ¼i½euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxrZ ",{"$nulls":8},{"$f":"IF(T14=T2,'Extra Ded. '!E8,\"0\")","v":{"v":0,"d":"0.00"}}]
[null," ¼ii½ O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",{"$nulls":8},{"$f":"IF(T14=T2,'Extra Ded. '!E9,\"0\")","v":{"v":0,"d":"0.00"}}]
[null," ¼iii½ LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",{"$nulls":8},{"$f":"IF(T14=T2,'Extra Ded. '!E7,\"0\")","v":50000},null,null,"#-",{"$f":"SUM(K8:M10)","v":50000}]
[6,"                                                           'ks\"k ¼4&5½",{"$nulls":11},"#-",{"$f":"O7-O10","v":446020}]
[7,"¼v½x`g lEifr ls vk;%¼1½ Loa; ds mi;ksx esa &'kwU;",{"$nulls":6},"¼2½ izkIr fdjk;k #-",null,{"$f":"'Extra Ded. '!E10","v":{"v":0,"d":"0.00"}}]
[null,"¼c½ ?kVk;sa ",null," fdjk;s dk 30%",null," x`g _.k ij C;kt",null,null," x`gdj ",null,"  ;ksx 7¼c½"]
[{"$nulls":3},{"$f":"IF(T14=T2,ROUND(K12*0.3,0),\"0\")","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(T14=T2,'Extra Ded. '!E13,\"0\")","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(T14=T2,'Extra Ded. '!E11,\"0\")","v":{"v":0,"d":"0.00"}},null,{"$f":"D14+F14+I14","v":{"v":0,"d":"0.00"}},{"$nulls":8},1]
[null," 'ks\"k &@$¼7¼v½ ,oa ;ksx 7¼c½ dk½  ",{"$nulls":11},"#-",{"$f":"K12-K14","v":0}]
[8,"cpr [kkrs ij C;kt %",null,null,{"$f":"'Extra Ded. '!I21","v":1000},null,"vU; vk;  %",null,{"$f":"'Extra Ded. '!E24","v":0},"dqy 'ks\"k &@$¼6,oa 7½",{"$nulls":3},"#-",{"$f":"O11+O15","v":446020}]
[9,",QMh vkfn vU; tek jkf'k ij izkIr dqy C;kt",null,null,{"$f":"'Extra Ded. '!I23","v":0},null,"Bonds ls C;kt",null,{"$f":"'Extra Ded. '!E23","v":0}," ;ksx ¼8$9½",{"$nulls":3},"#-",{"$f":"E16+E17+I16+I17","v":1000}]
[10,"ldy vk;                                                                                     ",{"$nulls":11},"#-",{"$f":"O16+O17","v":447020}]
[11,"?kVkb;s dVkSSfr;k¡ %& /kkjk US 80C, 80CCC,80CCD (1)",{"$nulls":15},"Move Curser Here"]
[null,"(A) vf/kdre lhek 1]50]000@& ¼/kkjk 80CCE ½ ] ¼/kkjk 80CCD (2), ds vykok"]
[null,"(i)","jkT; chek ¼SI)",null,null,"#-",{"$f":"IF(T14=T2,SUM('GA55 '!N27),\"0\")","v":0},"(xi)","isa'ku ;kstuk esa va'knku ECPF /kkjk 80ccd(1½\n",null,null,"#-",{"$f":"IF('Master Data'!I25='Master Data'!V18,0,IF(T14=T1,0,IF(T34=T36,AA27,AB23)))","v":44436}]
[null,"(ii)","Other AG Deducation ",null,null,"#-",{"$f":"IF(T14=T2,'GA55 '!Y27,\"0\")","v":0},"(xii)","isa'ku Iyku gsrq va'knku ¼/kkjk 80ccc½",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I12,\"0\")","v":0},{"$nulls":3},"https://www.youtube.com/watch?v=TJ5dWmZplAk"]
[null,"(iii)","jk\"Vªh; cpr i= ¼NSC)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E18,\"0\")","v":0},"(xiii)","jk\"Vªh; cpr i= ij vnr C;kt",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E19,\"0\")","v":0},{"$nulls":12},{"$f":"IF(AA23>AB23,AB23,AA23)","v":44436},{"$f":"IF('Master Data'!I25='Master Data'!V18,0,ROUND(10%*'GA55 '!M27,0))","v":45158},{"$f":"IF('Master Data'!I25='Master Data'!V19,'GA55 '!P27,0)","v":44436},{"$nulls":5},"E अधिक जानकारी के लिए देखें Youtube वीडियो"]
[null,"(iv)","yksd Hkfo\"; fuf/k ¼PPF)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E20,\"0\")","v":0},"(xiv)","V;w'ku Qhl ",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E16,\"0\")","v":0},{"$nulls":12},{"$f":"SUM(G21:G31)+SUM(M22:M30)+O33","v":46836},{"$f":"IF('Extra Ded. '!I14>50000,50000,'Extra Ded. '!I14)","v":50000},{"$f":"IF(Z24>150000,Z24-150000,0)","v":0}]
[null,"(v)","jk\"Vªh; cpr Ldhe ¼NSS)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E21,\"0\")","v":0},"(xv)","bfDoVh fyad lsfoax Ldhe",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I6,\"0\")","v":0}]
[null,"(vi)","lkekU; izko/kk;h fuf/k ¼GPF)",null,null,"#-",{"$f":"IF(AND(T14=T2,'Master Data'!I25='Master Data'!V18),'GA55 '!O27,\"0\")","v":"0"},"(xvi)","LFkfxr okf\"kZdh ¼Defferred Annuty)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I8,\"0\")","v":0},{"$nulls":3},"यदि आप NPS कार्मिक है और Section US 80CCD (1B) के अंतर्गत अधिकतम 50,000 की छूट लेना चाहते है तो यहाँ नीचे बॉक्स में क्लिक करे। "]
[null,"(vii)","lkewfgd chek izhfe;e ¼G.Ins.)",null,null,"#-",{"$f":"IF(T14=T2,'GA55 '!Q27,\"0\")","v":2400},"(xvii)","ih-,y-vkbZ- ¼PLI)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E15,\"0\")","v":0},{"$nulls":13},{"$f":"IFERROR(SUM(Z23)-MIN(AA24,AB24),0)","v":44436},null,{"$f":"MIN(AA24,AB24)","v":0}]
[null,"(viii)",";w- ,y- vkbZ- ih-@okf\"kZd Iyku",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E17,\"0\")","v":0},"(xviii)","vU; tekjkf'k ¼/kkjk 80 lh ds vUrxZr½ E;qpy QaM",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I10,\"0\")","v":0}]
[null,"(ix)","x`g _.k fdLr ¼HBA Premium)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E12,\"0\")","v":0},"(xix)","lqdU;k le`f) ;kstuk esa tek jkf'k",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E22,\"0\")","v":0},{"$nulls":13},{"$f":"IF(Z24>=200000,50000,AC27)","v":0}]
[null,"(x)","thou chek (Extra LIC)",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E14,\"0\")","v":0},"(xx)","vU; o fQDl fMiksftV ¼5 o\"kZ gsrq½",null,null,"#-",{"$f":"IF(T14=T2,'Extra Ded. '!E24,\"0\")","v":0}]
[null,"(xxi)",{"$nulls":3},"#-",null,";ksx ( i ls xviii )",{"$nulls":3},"#-",{"$f":"SUM(G21:G31)+SUM(M21:M30)","v":46836},{"$nulls":13},{"$f":"('Extra Ded. '!I23+'Extra Ded. '!I21)","v":1000}]
[null,"                        vf/kdre dVkSrh dh jkf'k 1-50 yk[k #i, rd",{"$nulls":11},"#-",{"$f":"IF(M31<150001,ROUND(M31,0),150000)","v":46836},null,null,"H","Move curser",{"$nulls":7},{"$f":"IF(AA31>10000,10000,AA31)","v":1000},{"$f":"IF(AA31>50000,50000,AA31)","v":1000}]
[null,"(B) ?kVkb;s& /kkjk 80CCD(2) fu;ksDrk }kjk isa'ku va'knku dh jkf'k ¼vf/kdre osru dk 10%) i`Fkd ls NwV",{"$nulls":12},{"$f":"IF('Master Data'!I25='Master Data'!V19,'GA55 '!P27,0)","v":44436},{"$nulls":11},{"$f":"IF('Master Data'!D18=\"Under 60\",AA32,IF('Master Data'!D18=\"Above 60\",AB32,IF('Master Data'!D18=\"Above 80\",AB32,0)))","v":1000}]
[null,"(C) ?kVkb;s & /kkjk 80CCD (1B) uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000)",{"$nulls":11},"#-",{"$f":"IF(T14=T1,0,IF(T34=T36,AB35,0))","v":0},{"$nulls":4},false]
[null,";ksx 11(A+B+C)      ",{"$nulls":11},"#-",{"$f":"SUM(O32:O34)","v":91272},{"$nulls":12},{"$f":"IF('Master Data'!I25='Master Data'!V19,AA29,0)","v":0}]
[12," vU; dVkSfr;k¡",{"$nulls":17},true]
[null,"1-/kkjk 80 D fpfdRlk chek izhfe;e ¼Lo;a]ifr@iRuh o cPpksa ds fy, : 25000] ekrk&firk ds fy, : 25000]lhfu;j flVhtu : 50000½",{"$nulls":11},"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I15,\"0\")","v":0}]
[null,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% ;k vf/kd fodykaxrk 125]000½",{"$nulls":11},"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I16,\"0\")","v":0},{"$nulls":12},{"$f":"'GA55 '!N27+'GA55 '!P27+'Extra Ded. '!E18+'Extra Ded. '!E20+'Extra Ded. '!E21+'GA55 '!O27+'GA55 '!Y27+'Extra Ded. '!E17+'Extra Ded. '!E12+'Extra Ded. '!E14+'Extra Ded. '!I12+'Extra Ded. '!E19+'Extra Ded. '!E16+'Extra Ded. '!I6+'Extra Ded. '!I8+'Extra Ded. '!E15+'Extra Ded. '!I10+'Extra Ded. '!E22+'Extra Ded. '!E24","v":44436}]
[null,"3- /kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½",{"$nulls":11},"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I17,\"0\")","v":0}]
[null,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",{"$nulls":11},"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I18,\"0\")","v":0},{"$nulls":12},{"$f":"'Extra Ded. '!I15+'Extra Ded. '!I16+'Extra Ded. '!I17+'Extra Ded. '!I18+('Extra Ded. '!I19+'GA55 '!U27)+'Extra Ded. '!I20+AA33+'Extra Ded. '!I22","v":1000}]
[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½ ¼dsUnz o jkT; ljdkj ds QaM esa ½",{"$nulls":11},"#-",{"$f":"IF(T14=T2,('Extra Ded. '!I19+'GA55 '!S27),\"0\")","v":12000},null,null,"यदि आपको धारा 80 TTA  के बारे में डिटेल से जानकारी चाहिए तो नीचे सेल पर माउस को ले जाइये। "]
[null,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½",{"$nulls":11},"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I20,\"0\")","v":0}]
[null,"7- /kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)  , ( ofj\"B ukxfjdks C;kt ij NwV 50000rd ½",{"$nulls":11},"#-",{"$f":"IF(T14=T2,AA33,\"0\")","v":1000}]
[null,"8- /kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku",{"$nulls":11},"#-",{"$f":"IF(T14=T2,'Extra Ded. '!I22,\"0\")","v":0},null,null,"Move Curser Here"]
[null,"dqy ;ksx 12 ¼ 1 ls 8 rd ½",{"$nulls":11},"#-",{"$f":"SUM(O37:O44)","v":13000}]
[13,"dqy dVkSrh ( 11 + 12)",{"$nulls":11},"#-",{"$f":"O35+O45","v":104272}]
[14,"dj ;ksX; vk; ( 10 - 13 )",{"$nulls":11},"#-",{"$f":"(O18-O46)","v":342748}]
[15,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",{"$nulls":11},"#-",{"$f":"ROUND(O47,-1)","v":342750}]
[16," vk;dj dh x.kuk  mijksDr dkWye 15 ds vk/kkj ij",{"$nulls":21},"old",{"$nulls":3},"New"]
[null,",d O;fDr dj nkrk",{"$nulls":3},"ofj\"B ukxfjd ¼60 ls 80 o\"kZ rd½",{"$nulls":3},"80 o\"kZ ;k vf/kd vk;q",{"$nulls":13},0,0,0,0,0,0,0,0]
[null,"Up to Rs. 2,50,000",null,null,{"v":0,"d":"0%"},{"$f":"IF(T14=T2,\"Up to Rs. 3,00,000\",\"Up to Rs. 2,50,000\")","v":"Up to Rs. 3,00,000"},null,null,{"v":0,"d":"0%"},{"$f":"IF(T14=T2,\"\",\"Up to Rs. 2,50,000\")","v":""},null,null,{"v":0,"d":"0%"},"#-",0,{"$nulls":8},{"$f":"ROUND(IF(O48<=250000,0,IF(O48>=500000,12500,IF(O48<=500000,0+(O48-250000)*0.05))),0)","v":4638},{"$f":"ROUND(IF(O48<=300000,0,IF(O48>=500000,10000,IF(O48<=500000,(O48-300000)*0.05))),0)","v":2138},0,{"$f":"IF('Master Data'!D18=\"Under 60\",X51,IF('Master Data'!D18=\"Above 60\",Y51,Z51))","v":4638},{"$f":"ROUND(IF(O48<250001,0,IF(O48>500000,12500,((O48-250000)*0.05))),0)","v":4638},{"$f":"ROUND(IF(O48<250001,0,IF(O48>500000,12500,((O48-250000)*0.05))),0)","v":4638},{"$f":"ROUND(IF(O48<250001,0,IF(O48>500000,12500,((O48-250000)*0.05))),0)","v":4638},{"$f":"IF('Master Data'!D18=\"Under 60\",AB51,IF('Master Data'!D18=\"Above 60\",AC51,AD51))","v":4638}]
[null,"2,50,001  to  5,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"IF(T14=T2,\"3,00,001 to 5,00,000\",\" 2,50,001 to  5,00,000\")","v":"3,00,001 to 5,00,000"},null,null,{"v":0.05,"d":"5%"},{"$f":"IF(T14=T2,\"Up to Rs. 5,00,000\",\"2,50,001 to  5,00,000\")","v":"Up to Rs. 5,00,000"},null,null,{"$f":"IF(T14=T2,\"0%\",\"5%\")","v":"0%"},"#-",{"$f":"IF($T$14=$T$2,AA51,AE51)","v":4638},{"$nulls":8},{"$f":"ROUND(IF(O48<=500000,0,IF(O48>=1000000,100000,IF(O48<=1000000,(O48-500000)*0.2,\"0\"))),0)","v":0},{"$f":"ROUND(IF(O48<=500000,0,IF(O48>=1000000,100000,IF(O48<=1000000,(O48-500000)*0.2,\"0\"))),0)","v":0},{"$f":"ROUND(IF(O48<=500000,0,IF(O48>=1000000,100000,IF(O48<=1000000,(O48-500000)*0.2,\"0\"))),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",X52,IF('Master Data'!D18=\"Above 60\",Y52,Z52))","v":0},{"$f":"ROUND(IF(O48<500001,0,IF(O48>750000,25000,((O48-500000)*0.1))),0)","v":0},{"$f":"ROUND(IF(O48<500001,0,IF(O48>750000,25000,((O48-500000)*0.1))),0)","v":0},{"$f":"ROUND(IF(O48<500001,0,IF(O48>750000,25000,((O48-500000)*0.1))),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",AB52,IF('Master Data'!D18=\"Above 60\",AC52,AD52))","v":0}]
[null,{"$f":"IF(T14=T2,\"5,00,001 to 10,00,000\",\"5,00,001  to  7,50,000\")","v":"5,00,001 to 10,00,000"},null,null,{"$f":"IF(T14=T2,\"20%\",\"10%\")","v":"20%"},{"$f":"IF(T14=T2,\"5,00,001 to 10,00,000\",\"5,00,001  to  7,50,000\")","v":"5,00,001 to 10,00,000"},null,null,{"$f":"IF(T14=T2,\"20%\",\"10%\")","v":"20%"},{"$f":"IF(T14=T2,\"5,00,001 to 10,00,000\",\"5,00,001  to  7,50,000\")","v":"5,00,001 to 10,00,000"},null,null,{"$f":"IF(T14=T2,\"20%\",\"10%\")","v":"20%"},"#-",{"$f":"IF($T$14=$T$2,AA52,AE52)","v":0},{"$nulls":8},{"$f":"ROUND(IF(O48>1000000,(O48-1000000)*0.3,\"0\"),0)","v":0},{"$f":"ROUND(IF(O48>1000000,(O48-1000000)*0.3,\"0\"),0)","v":0},{"$f":"ROUND(IF(O48>1000000,(O48-1000000)*0.3,\"0\"),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",X53,IF('Master Data'!D18=\"Above 60\",Y53,Z53))","v":0},{"$f":"ROUND(IF(O48<750001,0,IF(O48>1000000,37500,((O48-750000)*0.15))),0)","v":0},{"$f":"ROUND(IF(O48<750001,0,IF(O48>1000000,37500,((O48-750000)*0.15))),0)","v":0},{"$f":"ROUND(IF(O48<750001,0,IF(O48>1000000,37500,((O48-750000)*0.15))),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",AB53,IF('Master Data'!D18=\"Above 60\",AC53,AD53))","v":0}]
[null,{"$f":"IF(T14=T2,\"Above  10,00,000\",\" 7,50,001 to  10,00,000\")","v":"Above  10,00,000"},null,null,{"$f":"IF(T14=T2,\"30%\",\"15%\")","v":"30%"},{"$f":"IF(T14=T2,\"Above  10,00,000\",\" 7,50,001 to  10,00,000\")","v":"Above  10,00,000"},null,null,{"$f":"IF(T14=T2,\"30%\",\"15%\")","v":"30%"},{"$f":"IF(T14=T2,\"Above  10,00,000\",\" 7,50,001 to  10,00,000\")","v":"Above  10,00,000"},null,null,{"$f":"IF(T14=T2,\"30%\",\"15%\")","v":"30%"},"#-",0,{"$nulls":11},{"$f":"IF('Master Data'!D18=\"Under 60\",X54,IF('Master Data'!D18=\"Above 60\",Y54,Z54))","v":0},{"$f":"ROUND(IF(O48<1000001,0,IF(O48>1250000,50000,((O48-1000000)*0.2))),0)","v":0},{"$f":"ROUND(IF(O48<1000001,0,IF(O48>1250000,50000,((O48-1000000)*0.2))),0)","v":0},{"$f":"ROUND(IF(O48<1000001,0,IF(O48>1250000,50000,((O48-1000000)*0.2))),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",AB54,IF('Master Data'!D18=\"Above 60\",AC54,AD54))","v":0}]
[null,{"$f":"IF(T14=T2,\" \",\"10,00,001 to  12,50,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"20%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"10,00,001 to  12,50,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"20%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"10,00,001 to  12,50,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"20%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"#-\")","v":" "},{"$f":"IF($T$14=$T$2,AA54,AE54)","v":0},null,null,"यदि आपको धारा 87A  के बारे में जानकारी चाहिए तो नीचे सेल पर माउस को ले जाइये। ",{"$nulls":8},{"$f":"IF('Master Data'!D18=\"Under 60\",X55,IF('Master Data'!D18=\"Above 60\",Y55,Z55))","v":0},{"$f":"ROUND(IF(O48<1250001,0,IF(O48>1500000,62500,((O48-1250000)*0.25))),0)","v":0},{"$f":"ROUND(IF(O48<1250001,0,IF(O48>1500000,62500,((O48-1250000)*0.25))),0)","v":0},{"$f":"ROUND(IF(O48<1250001,0,IF(O48>1500000,62500,((O48-1250000)*0.25))),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",AB55,IF('Master Data'!D18=\"Above 60\",AC55,AD55))","v":0}]
[null,{"$f":"IF(T14=T2,\" \",\"12,50,001 to  15,00,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"25%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"12,50,001 to  15,00,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"25%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"12,50,001 to  15,00,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"25%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"#-\")","v":" "},0,{"$nulls":11},{"$f":"IF('Master Data'!D18=\"Under 60\",X56,IF('Master Data'!D18=\"Above 60\",Y56,Z56))","v":0},{"$f":"ROUND(IF(O48<1500001,0,(O48-1500000)*0.3),0)","v":0},{"$f":"ROUND(IF(O48<1500001,0,(O48-1500000)*0.3),0)","v":0},{"$f":"ROUND(IF(O48<1500001,0,(O48-1500000)*0.3),0)","v":0},{"$f":"IF('Master Data'!D18=\"Under 60\",AB56,IF('Master Data'!D18=\"Above 60\",AC56,AD56))","v":0}]
[null,{"$f":"IF(T14=T2,\" \",\"Above Rs. 15,00,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"30%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"Above Rs. 15,00,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"30%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"Above Rs. 15,00,000\")","v":" "},null,null,{"$f":"IF(T14=T2,\" \",\"30%\")","v":" "},{"$f":"IF(T14=T2,\" \",\"#-\")","v":" "},{"$f":"IF($T$14=$T$2,AA56,AE56)","v":0},{"$nulls":8},{"$f":"SUM(X50:X53)","v":4638},{"$f":"SUM(Y50:Y53)","v":2138},0,{"$f":"IF('Master Data'!D18=\"Under 60\",X57,IF('Master Data'!D18=\"Above 60\",Y57,Z57))","v":4638},{"$f":"SUM(AB50:AB56)","v":4638},{"$f":"SUM(AC50:AC56)","v":4638},4638,{"$f":"IF('Master Data'!D18=\"Under 60\",AB57,IF('Master Data'!D18=\"Above 60\",AC57,AD57))","v":4638}]
[null,"¼1½ ;ksx vk;dj",{"$nulls":11},"#-",{"$f":"SUM(O51:O57)","v":4638}]
[null,"¼2½ NwV ?kkjk 87¼A½ ¼ 5yk[k rd dh dj ;ksX; vk; ij vk;dj dh NwV vf/kdre :- 12500@& rd½",{"$nulls":11},"#-",{"$f":"IF(O48>500000,0,IF(O58<12500,O58,12500))","v":4638},{"$nulls":8},{"$f":"ROUND(IF(O48<=250000,0,IF(O48<=500000,(O48-250000)*0.05,IF(O48<=1000000,12500+(O48-500000)*0.2,IF(O48>1000000,112500+(O48-1000000)*0.3,\"0\")))),0)","v":4638},{"$f":"ROUND(IF(O48<=300000,0,IF(O48<=500000,(O48-300000)*0.05,IF(O48<=1000000,10000+(O48-500000)*0.2,IF(O48>1000000,110000+(O48-1000000)*0.3,\"0\")))),0)","v":2138},{"$f":"ROUND(IF(O48<=250000,0,IF(O48<=500000,(O48-250000)*0.05,IF(O48<=1000000,0+(O48-500000)*0.2,IF(O48>1000000,100000+(O48-1000000)*0.3,\"0\")))),0)","v":4638}]
[null,"¼3½ 'ks\"k vk;dj ¼1&2½",{"$nulls":11},"#-",{"$f":"O58-O59","v":0},{"$nulls":9},{"$f":"IF(T63>350000,0,IF(T63<2501,T63,2500))","v":0}]
[null,"¼4½ ","f'k{kk ,oa fpfdRlk midj  4%  ¼vk;dj ij ½",{"$nulls":10},"#-",{"$f":"ROUND((O60*0.04),0)","v":0}]
[null,"                                                             dqy vk;dj ¼3$4½",{"$nulls":11},"#-",{"$f":"SUM(O60:O61)","v":0}]
[17,"?kVkb;s  %& jkgr /kkjk 89 ds rgr ",{"$nulls":11},"#-",{"$f":"'Extra Ded. '!I24","v":0}]
[18,"dqy 'ks\"k vk;dj",{"$nulls":11},"#-",{"$f":"O62-O63","v":0}]
[19," vk;dj dVkSrh\n dk fooj.k",null,null,"flrEcj 2020\nrd  :i;s",null,null,"vDVwcj ls fnlEcj\n2020 :i;s",null,"tuojh 2021\n:i;s","Qjojh 2021\n:i;s",null,"Vh-Mh-,l-\n:Ik;s",null,"dqy;ksx dkWye 19 "]
[{"$nulls":4},{"$f":"SUM('GA55 '!T6:T12)","v":1456},null,null,{"$f":"SUM('GA55 '!T13:T15)","v":624},null,{"$f":"'GA55 '!T16","v":208},{"$f":"'GA55 '!T17","v":208},null,{"$f":"SUM('GA55 '!T27-(E66+H66+J66+K66))+'Extra Ded. '!I9","v":0},null,{"$f":"SUM(E66,H66,J66,K66,M66)","v":2496}]
[{"$f":"IF(O64>O66,\"Income Tax Payable\",IF(O64<O66,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Refundable"},{"$nulls":12},"#-",{"$f":"IF(O64>O66,O64-O66,O66-O64)","v":2496}]
[]
[{"$nulls":11},"gLrk{kj dkfeZd"]

{"sheet":"Form No. 16","index":5,"n_rows":141,"n_cols":11,"rows_kept":141,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,5],[4,6,4,11],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,3],[7,4,7,5],[7,6,7,8],[7,9,7,11],[8,1,8,3],[8,4,8,5],[8,6,8,8],[8,9,8,11],[9,1,9,5],[9,6,9,7],[9,8,9,11],[10,2,10,5],[10,6,11,7],[10,8,10,9],[10,10,10,11],[11,2,11,3],[11,8,11,9],[11,10,11,11],[12,1,12,11],[13,2,13,4],[13,6,13,8],[13,9,13,11],[14,2,14,4],[14,6,14,8],[14,9,14,11],[15,2,15,4],[15,6,15,8],[15,9,15,11],[16,2,16,4],[16,6,16,8],[16,9,16,11],[17,2,17,4],[17,6,17,8],[17,9,17,11],[18,1,18,4],[18,6,18,8],[18,9,18,11],[19,1,19,11],[20,1,20,11],[21,1,22,1],[21,2,22,3],[21,4,21,11],[22,6,22,8],[22,9,22,11],[23,2,23,3],[23,6,23,8],[23,9,23,11],[24,2,24,3],[24,6,24,8],[24,9,24,11],[25,2,25,3],[25,6,25,8],[25,9,25,11],[26,2,26,3],[26,6,26,8],[26,9,26,11],[27,2,27,3],[27,6,27,8],[27,9,27,11],[28,2,28,3],[28,6,28,8],[28,9,28,11],[29,2,29,3],[29,6,29,8],[29,9,29,11],[30,2,30,3],[30,6,30,8],[30,9,30,11],[31,2,31,3],[31,6,31,8],[31,9,31,11],[32,2,32,3],[32,6,32,8],[32,9,32,11],[33,2,33,3],[33,6,33,8],[33,9,33,11],[34,2,34,3],[34,6,34,8],[34,9,34,11],[35,2,35,3],[35,6,35,8],[35,9,35,11],[36,2,36,3],[36,6,36,8],[36,9,36,11],[37,2,37,3],[37,4,37,11],[38,1,38,11],[39,1,39,11],[40,1,41,1],[40,2,41,3],[40,4,40,11],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,11],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[55,10,55,11],[56,2,56,3],[56,4,56,11],[57,1,57,11],[58,1,58,11],[59,2,59,4],[59,6,59,9],[59,10,59,11],[60,1,60,2],[60,3,60,5],[60,6,60,11],[61,3,61,7],[61,8,61,11],[62,1,62,11],[63,1,63,11],[64,1,64,2],[64,3,64,4],[64,5,64,11],[65,1,65,2],[65,3,65,4],[65,5,65,11],[66,1,66,2],[66,3,66,4],[66,6,66,11],[67,1,67,11],[68,1,68,11],[69,1,69,5],[69,6,69,7],[69,8,72,9],[69,10,85,11],[70,1,70,5],[70,6,70,7],[71,1,71,5],[71,6,71,7],[72,1,72,5],[72,6,72,7],[73,1,73,5],[73,6,76,7],[73,8,73,9],[74,1,74,5],[74,8,77,9],[75,1,75,5],[76,1,76,3],[77,1,77,3],[77,6,77,7],[78,1,78,5],[78,6,79,7],[78,8,78,9],[79,1,79,5],[79,8,82,9],[80,1,80,2],[80,3,80,5],[80,6,80,7],[81,1,81,2],[81,3,81,5],[81,6,81,7],[82,1,82,2],[82,3,82,5],[82,6,82,7],[83,1,83,2],[83,3,83,4],[83,6,84,7],[83,8,83,9],[84,1,84,2],[84,3,84,4],[84,8,84,9],[85,1,85,5],[85,6,93,7],[85,8,85,9],[86,1,86,5],[86,8,89,9],[86,10,86,11],[87,1,87,5],[87,10,90,11],[88,1,88,4],[89,1,89,4],[90,1,90,4],[90,8,90,9],[91,1,91,5],[91,8,93,9],[91,10,91,11],[92,1,92,5],[92,10,93,11],[93,1,93,5],[94,1,94,5],[94,6,94,7],[94,8,94,9],[94,10,94,11],[95,1,109,1],[95,3,107,3],[95,4,95,5],[95,6,95,7],[95,8,106,9],[95,10,106,11],[96,4,96,5],[96,6,96,7],[97,4,97,5],[97,6,97,7],[98,4,98,5],[98,6,98,7],[99,4,99,5],[99,6,99,7],[100,4,100,5],[100,6,100,7],[101,4,101,5],[101,6,101,7],[102,4,102,5],[102,6,102,7],[103,4,103,5],[103,6,103,7],[104,4,104,5],[104,6,104,7],[105,4,105,5],[105,6,105,7],[106,4,106,5],[106,6,106,7],[107,4,107,5],[107,6,107,7],[107,8,107,9],[107,10,107,11],[108,2,108,5],[108,6,108,7],[108,8,108,9],[108,10,108,11],[109,2,109,5],[109,6,109,7],[109,8,109,9],[109,10,109,11],[110,8,110,10],[111,1,111,11],[112,1,112,5],[112,6,112,7],[112,8,112,9],[112,10,112,11],[113,2,113,5],[113,6,113,7],[113,8,113,9],[113,10,120,11],[114,2,114,5],[114,6,114,7],[114,8,114,9],[115,2,115,5],[115,6,115,7],[115,8,115,9],[116,2,116,5],[116,6,116,7],[116,8,116,9],[117,2,117,5],[117,6,117,7],[117,8,117,9],[118,2,118,5],[118,6,118,7],[118,8,118,9],[119,2,119,5],[119,6,119,7],[119,8,119,9],[120,2,120,5],[120,6,120,7],[120,8,120,9],[121,2,121,5],[121,6,121,7],[121,8,121,9],[121,10,121,11],[122,1,122,5],[122,6,122,7],[122,8,122,9],[122,10,122,11],[123,1,123,3],[123,4,123,5],[123,6,123,7],[123,8,123,9],[123,10,123,11],[124,1,124,9],[124,10,124,11],[125,1,125,5],[125,8,125,9],[125,10,125,11],[126,1,126,5],[126,6,126,7],[126,8,126,9],[126,10,126,11],[127,1,127,5],[127,6,127,7],[127,8,127,9],[127,10,127,11],[128,1,128,5],[128,6,128,7],[128,8,128,9],[128,10,128,11],[129,1,129,5],[129,6,129,7],[129,8,129,9],[129,10,129,11],[130,1,130,5],[130,6,130,7],[130,8,130,9],[130,10,130,11],[131,1,131,9],[131,10,131,11],[132,1,132,9],[132,10,132,11],[133,1,133,11],[134,2,134,4],[134,6,134,9],[134,10,134,11],[135,1,135,2],[135,3,135,5],[135,6,135,11],[136,3,136,7],[136,8,136,11],[137,1,137,11],[138,1,138,2],[138,3,138,4],[138,5,138,11],[139,1,139,2],[139,3,139,4],[139,5,139,11],[140,1,140,2],[140,3,140,4],[140,6,140,11]]}
[null,"FORM NO. 16"]
[null,"[(See Rule 31(1)(a)]"]
[null,"PART-A"]
[null,"Certificate under section 203 of the income-tax act, 1961 for Tax deducted at source on Salary."]
[null,"Name and address of the Employer",{"$nulls":4},"Name and adress of the Employee"]
[null,{"$f":"IF('Master Data'!H8=\"\",\"\",UPPER('Master Data'!H8))","v":"B.E.O.PICHHOR"},{"$nulls":4},{"$f":"IF('Master Data'!D6=\"\",\"\",UPPER('Master Data'!D6))","v":"HEERALAL JAT"}]
[{"$nulls":6},{"$f":"IF('Master Data'!D8=\"\",\"\",UPPER('Master Data'!D8))","v":"GHS HARIJAN BASTI PICHHORE "}]
[null,"PAN of the Deductor",null,null,"TAN of  the Deductor",null,"PAN of the Employee",null,null,"Employee Ref No."]
[{"$nulls":4},{"$f":"'Master Data'!H12","v":0},null,{"$f":"UPPER('Master Data'!D12)","v":"ABCDE1234H"},null,null,{"$f":"UPPER('Master Data'!D10)","v":"390263384"}]
[null,"CIT (TDS)",{"$nulls":4},"Assess. Year",null,"Peroid with the Employer"]
[null,"Adress","The Commissioner of Income Tax, Pali",{"$nulls":3},"2021-22",null,"From",null,"To"]
[null,"City","PALI",null,"PIN Code",306401,null,null,"01-4-2020",null,"31-03-2021"]
[null,"Summary of amount paid/credited and tax deducted at source thereon in respect of the employee"]
[null,"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.)"]
[null,"1st ",{"$nulls":4},{"$f":"SUM('GA55 '!T6:T8)","v":{"v":624,"d":"Rs. 624"}},null,null,{"$f":"G15","v":{"v":624,"d":"Rs. 624"}}]
[null,"2nd ",{"$nulls":4},{"$f":"SUM('GA55 '!T9:T11)","v":{"v":624,"d":"Rs. 624"}},null,null,{"$f":"G16","v":{"v":624,"d":"Rs. 624"}}]
[null,"3rd  ",{"$nulls":4},{"$f":"SUM('GA55 '!T12:T14)","v":{"v":624,"d":"Rs. 624"}},null,null,{"$f":"G17","v":{"v":624,"d":"Rs. 624"}}]
[null,"4th ",{"$nulls":4},{"$f":"SUM('GA55 '!T15:T26)","v":{"v":624,"d":"Rs. 624"}},null,null,{"$f":"G18","v":{"v":624,"d":"Rs. 624"}}]
[null,"TOTAL (Rs.)",{"$nulls":3},{"$f":"SUM(F15:F18)","v":{"v":0,"d":"Rs. 0"}},{"$f":"SUM(G15:G18)","v":{"v":2496,"d":"Rs. 2,496"}},null,null,{"$f":"SUM(J15:J18)","v":{"v":2496,"d":"Rs. 2,496"}}]
[null,"I. Details of tax deducted and deposited in the Central Government account through book adjustment"]
[null,"(The Deductor to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
[null,"S.N.","Tax Deposited in respect of the deductee (Rs)",null,"Book identification number (BIN)"]
[{"$nulls":4},"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"]
[null,1,{"$f":"'GA55 '!X6","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},{"$f":"IF(E24>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,2,{"$f":"'GA55 '!X7","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},{"$f":"IF(E25>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,3,{"$f":"'GA55 '!X8","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,4,{"$f":"'GA55 '!X9","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,5,{"$f":"'GA55 '!X10","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,6,{"$f":"'GA55 '!X11","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,7,{"$f":"'GA55 '!X12","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,8,{"$f":"'GA55 '!X13","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,9,{"$f":"'GA55 '!X14","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,10,{"$f":"'GA55 '!X15","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,11,{"$f":"'GA55 '!X16","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,12,{"$f":"'GA55 '!X17","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,13,{"$f":"SUM(C24:D34)-'GA55 '!X27","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,14,{"$f":"'[2]G.A. 55'!T24+'[2]G.A. 55'!T26","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,"Total",{"$f":"SUM(C24:D37)","v":{"v":0,"d":"Rs. 0"}}]
[null,"II. Details of Tax deducted and deposited in Central Government Account through Challan. "]
[null,"(The deducter to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
[null,"S.N.","Tax Deposited in respect on of the deductee (Rs)",null,"Challan identification number (CIN)"]
[{"$nulls":4},"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"]
[null,1,{"$nulls":8},{"$f":"IF(C43>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,2,{"$nulls":8},{"$f":"IF(C44>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,3,{"$nulls":8},"-"]
[null,4,{"$nulls":8},"-"]
[null,5,{"$nulls":8},"-"]
[null,6,{"$nulls":8},"-"]
[null,7,{"$nulls":8},"-"]
[null,8,{"$nulls":8},"-"]
[null,9,{"$nulls":8},"-"]
[null,10,{"$nulls":8},"-"]
[null,11,{"$nulls":8},"-"]
[null,12,{"$nulls":8},"-"]
[null,13]
[null,14]
[null,"Total",{"$f":"SUM(C43:C56)","v":0}]
[null,":: 2 ::"]
[null,"Verification"]
[null,"I",{"$f":"B6&\",\"","v":"B.E.O.PICHHOR,"},null,null,"Son/Daughter of ",{"$nulls":4},"working in the "]
[null,"capacity of ",null,"PRINCIPAL",null,null,"(designation) do hereby certify that a sum of "]
[null,"Rs.",{"$f":"J19","v":{"v":2496,"d":"2496.00"}},{"$f":"IF(OR(LEN(FLOOR(C62,1))=13,FLOOR(C62,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(C62>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(C62,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",C62,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[2]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('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]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('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]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('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]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":"Two Thousand Four Hundred Ninety-Six Rupees"},{"$nulls":4},"(in words) has been deducted "]
[null,"and deposited to the credit of the Central Govt.. I further certify that the information given above is true, complete and correct "]
[null,"and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
[null,"Place",null,{"$f":"G7","v":"GHS HARIJAN BASTI PICHHORE "}]
[null,"Date",null,{"$f":"TODAY()","v":"2020-12-20"},null,"Signature of person responsible for deduction of tax"]
[null,"Designation",null,{"$f":"D61","v":"PRINCIPAL"},null,"Full name :",{"$f":"B6","v":"B.E.O.PICHHOR"}]
[null,"PART- B (Annexure)"]
[null,"DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[null,"1. Gross salary"]
[null,"(a) Salary as per provisions contained in section 17(1)",{"$nulls":4},{"$f":"COMPUTATION!O4+COMPUTATION!O5","v":{"v":496020,"d":"Rs. 496,020.00"}}]
[null,"(b) Value of perquisites u/s 17(2) (as per Form No. 12BA, wherever applicable)"]
[null,"(c) Profits in lieu of salary under section 17(3) (as per Form No. 12BA, wherever applicable)",{"$nulls":4},0]
[null,"(d) Total  (a+b+c)",{"$nulls":6},{"$f":"G71+G72+G73","v":{"v":496020,"d":"Rs. 496,020.00"}}]
[null,"2. Less: Allowance to the extent exempt u/s 10 House Rent Allowance"]
[null,"Allowance"]
[null,"House Rent Allow. US10 (13 A)",null,null,{"$f":"COMPUTATION!O6","v":0},{"$f":"E77","v":0}]
[null,"US10 (14)",{"$nulls":3},0,{"$f":"F77+F78","v":0}]
[null,"3. Balance (1 - 2)",{"$nulls":6},{"$f":"I74-G78","v":{"v":496020,"d":"Rs. 496,020.00"}}]
[null,"4. Deductions: U/s 16"]
[null,"(a)",null,"Standard Deduction (u/s 16 (ia)",null,null,{"$f":"COMPUTATION!K10","v":{"v":50000,"d":"Rs. 50,000.00"}}]
[null,"(b)",null,"Entertainment allowance",null,null,{"$f":"COMPUTATION!K8","v":0}]
[null,"(c)",null,"Tax on employment",null,null,{"$f":"COMPUTATION!K9","v":0}]
[null,"किराये का 30%",null,"गृह ऋण पर ब्याज",null,"गृहकर",null,null,{"$f":"G82+G83+G81","v":{"v":50000,"d":"Rs. 50,000.00"}}]
[null,{"$f":"COMPUTATION!D14","v":0},null,{"$f":"COMPUTATION!F14","v":0},null,{"$f":"COMPUTATION!I14","v":0},null,null,{"$f":"B85+D85+F85","v":0}]
[null,"5. Aggregate of 4 (a) and (b)",{"$nulls":6},{"$f":"I84+I85","v":{"v":50000,"d":"Rs. 50,000.00"}}]
[null,"6. Income chargeable under the head \"salaries\" (3-5)",{"$nulls":8},{"$f":"I79-I86","v":{"v":446020,"d":"Rs. 446,020.00"}}]
[null,"7. Add: Any other income reported by employee "]
[null,"Income",{"$nulls":3},"Rs"]
[null,"From House Property",{"$nulls":3},{"$f":"COMPUTATION!K12","v":{"v":0,"d":"0.00"}}]
[null,"Saving Bank A/C interest",{"$nulls":3},{"$f":"COMPUTATION!E16","v":{"v":1000,"d":"1000.00"}},null,null,{"$f":"F90+F91","v":{"v":1000,"d":"Rs. 1,000.00"}}]
[null,"8. Gross total income (6+7)",{"$nulls":8},{"$f":"K87+I91","v":{"v":447020,"d":"Rs. 447,020.00"}}]
[null,"9. Deductions under Chapter VI A"]
[null,"(A) Section 80C, 80CCC and 80CCD"]
[null,"(a) Section 80C",{"$nulls":6},"Gross Amount",null,"Deductible Amount"]
[null,"A",1,"(A)","GPF",null,{"$f":"COMPUTATION!G26","v":"0"}]
[null,null,2,null,"State Insurance",null,{"$f":"COMPUTATION!G21","v":0}]
[null,null,3,null,"Gr. Acc. Insurance",null,{"$f":"COMPUTATION!G27","v":{"v":2400,"d":"Rs. 2,400.00"}}]
[null,null,4,null,"LIC + ULIP + PLI",null,{"$f":"COMPUTATION!G22+COMPUTATION!G30+COMPUTATION!M27+COMPUTATION!G28","v":0}]
[null,null,5,null,"PPF",null,{"$f":"COMPUTATION!G24","v":0}]
[null,null,6,null,"Home Loan Installment (Capital)",null,{"$f":"COMPUTATION!G29","v":0}]
[null,null,7,null,"Notified Bond Of NABARD",null,{"$f":"'[2]TAX (OLD)'!L21","v":0}]
[null,null,8,null,"Pension Plan (US80ccc+US 80CCD)(1)+GPF-2004",null,{"$f":"COMPUTATION!M21+COMPUTATION!M22+COMPUTATION!G31","v":{"v":44436,"d":"Rs. 44,436.00"}}]
[null,null,9,null,"Tution Fee",null,{"$f":"COMPUTATION!M24","v":0}]
[null,null,10,null,"NSC + Interest on NSC",null,{"$f":"COMPUTATION!G25+COMPUTATION!M23","v":0}]
[null,null,11,null,"Sukanya Samridhi A/C",null,{"$f":"COMPUTATION!M29","v":0}]
[null,null,12,null,"Fixed Deposit above 5 years",null,{"$f":"COMPUTATION!M30","v":0}]
[null,null,13,null,"Mutual Fund",null,{"$f":"COMPUTATION!M28","v":0},null,{"$f":"SUM(G96:H108)","v":{"v":46836,"d":"Rs. 46,836.00"}},null,{"$f":"IF(I108<=150000, I108, 150000)","v":{"v":46836,"d":"Rs. 46,836.00"}}]
[null,null,"(B) Section 80CCD(2)",{"$nulls":3},{"$f":"COMPUTATION!O33","v":{"v":44436,"d":"Rs. 44,436.00"}},null,{"$f":"G109","v":{"v":44436,"d":"Rs. 44,436.00"}},null,{"$f":"I109","v":{"v":44436,"d":"Rs. 44,436.00"}}]
[null,null,"(C) Section 80CCD(1B)  (RS.-50000/-)",{"$nulls":3},{"$f":"COMPUTATION!O34","v":0},null,{"$f":"SUM(K108,G109,G110)","v":{"v":91272,"d":"Rs. 91,272.00"}},null,{"$f":"I110","v":{"v":91272,"d":"Rs. 91,272.00"}}]
[{"$nulls":8},"………………… 3"]
[null,":: 3 ::"]
[null,"(B) Other Sections (e.g. 80E, 80G etc.) under Chapter VIA",{"$nulls":4},"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
[null,1,"U/S 80D",{"$nulls":3},{"$f":"COMPUTATION!O37","v":0},null,{"$f":"G114","v":0}]
[null,2,"U/S 80DD",{"$nulls":3},{"$f":"COMPUTATION!O38","v":0},null,0]
[null,3,"U/S 80DDB",{"$nulls":3},{"$f":"COMPUTATION!O39","v":0},null,0]
[null,4,"U/S 80E",{"$nulls":3},{"$f":"COMPUTATION!O40","v":0},null,0]
[null,5,"U/S 80G",{"$nulls":3},{"$f":"COMPUTATION!O41","v":{"v":12000,"d":"Rs. 12,000.00"}},null,{"v":12000,"d":"Rs. 12,000.00"}]
[null,6,"U/S 80GG",{"$nulls":5},0]
[null,7,"U/S 80GGA",{"$nulls":3},{"$f":"COMPUTATION!O44","v":0},null,0]
[null,8,"U/S 80U",{"$nulls":3},{"$f":"COMPUTATION!O42","v":0},null,0]
[null,9,"US 80TTA [Exempt Saving Bank Int. Max. RS. 10,000/-]",{"$nulls":3},{"$f":"COMPUTATION!O43","v":{"v":1000,"d":"Rs. 1,000.00"}},null,{"$f":"G122","v":{"v":1000,"d":"Rs. 1,000.00"}},null,{"$f":"ROUND(SUM(I114:J122),0)","v":{"v":13000,"d":"Rs. 13,000.00"}}]
[null,"10. Aggregate of deductible amount under chapter VIA ",{"$nulls":8},{"$f":"ROUND((K110+K122),0)","v":{"v":104272,"d":"Rs. 104,272.00"}}]
[null,"11. Total income (8-10)",null,null,"(Roundup Figures of Rs 10)",{"$nulls":5},{"$f":"ROUND((K92-K123),-1)","v":{"v":342750,"d":"Rs. 342,750.00"}}]
[null,"12. Tax on total income",{"$nulls":8},{"$f":"ROUND(IF(K124<=250000,0,IF(K124<=500000,(K124-250000)*0.05,IF(K124<=1000000,12500+(K124-500000)*0.2,IF(K124>1000000,112500+(K124-1000000)*0.3,\"0\")))),0)","v":{"v":4638,"d":"Rs. 4,638.00"}}]
[null,"13. Rebate U/s 87 A (Taxable Income below Rs. 5,00,000/-)",{"$nulls":6},{"$f":"COMPUTATION!O59","v":{"v":4638,"d":"Rs. 4,638.00"}}]
[null,"14. Tax payable (12-13)",{"$nulls":8},{"$f":"K125-I126","v":0}]
[null,"15. Education & Health cess @ 4% (on tax computed at S.No. 12)",{"$nulls":8},{"$f":"ROUND((K127*0.04),0)","v":0}]
[null,"16. Tax payable (14+15) [Round off U/s 288 B]",{"$nulls":8},{"$f":"K127+K128","v":0}]
[null,"17. Less:- Relief under section 89 (Attach Form 10E)",{"$nulls":8},{"$f":"COMPUTATION!O63","v":0}]
[null,"18. Tax payable (14-15)",{"$nulls":8},{"$f":"K129-K130","v":0}]
[null,"19. Tax deducted at source u/s 192 (1)",{"$nulls":8},{"$f":"COMPUTATION!O66","v":{"v":2496,"d":"Rs. 2,496.00"}}]
[null,{"$f":"IF(K131>K132,\"Income Tax Payable\",IF(K131<K132,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Refundable"},{"$nulls":8},{"$f":"IF(K131>K132,K131-K132,K132-K131)","v":{"v":2496,"d":"Rs. 2,496.00"}}]
[null,"Verification"]
[null,"I",{"$f":"B6&\",\"","v":"B.E.O.PICHHOR,"},null,null,"Son/Daughter of ",{"$f":"IF(G60=\"\",\"\",G60)","v":""},{"$nulls":3},"working in the "]
[null,"capacity of ",null,{"$f":"D61","v":"PRINCIPAL"},null,null,"(designation) do hereby certify that a sum of "]
[null,"Rs.",{"$f":"K132","v":2496},{"$f":"IF(OR(LEN(FLOOR(C62,1))=13,FLOOR(C62,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(C62>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(C62),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(C62),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C62),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(C62),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(C62,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",C62,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[2]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('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]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('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]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('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]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":"Two Thousand Four Hundred Ninety-Six Rupees"},{"$nulls":4},"(in words) has beeen deducted and "]
[null,"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."]
[null,"Place",null,{"$f":"D65","v":"GHS HARIJAN BASTI PICHHORE "}]
[null,"Date",null,{"$f":"TODAY()","v":"2020-12-20"},null,"Signature of person responsible for deduction of tax"]
[null,"Designation",null,{"$f":"D136","v":"PRINCIPAL"},null,"Full name :",{"$f":"B6","v":"B.E.O.PICHHOR"}]