{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["info","GA55","7pay matrix chart","TAX CALCULATION","OLD TAX REGIME","NEW TAX REGIME","PAY SLIP"],"not_rendered":{"images":4,"macros":1,"defined_names":24,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"info","index":0,"n_rows":33,"n_cols":14,"rows_kept":33,"merged":[[1,1,1,15],[2,1,2,15],[3,1,3,15],[4,1,8,1],[4,2,4,15],[5,2,5,15],[6,2,6,15],[7,2,7,15],[8,2,8,15],[9,1,10,1],[9,2,9,15],[10,2,10,15],[11,1,12,1],[11,2,11,15],[12,2,12,15],[13,1,14,1],[13,2,13,15],[14,2,14,15],[15,1,16,1],[15,2,15,15],[16,2,16,15],[17,1,18,1],[17,2,17,15],[18,2,18,15],[19,2,19,15],[20,1,21,4],[20,5,21,8],[20,9,21,10],[20,11,21,15],[22,3,22,15],[23,3,23,15],[24,3,24,15],[25,6,25,7],[25,8,25,15],[26,3,26,15],[27,3,29,5],[27,6,29,8],[27,9,29,12],[27,13,29,15],[30,3,31,8],[30,9,31,12],[30,13,31,15],[32,1,33,6],[32,7,33,9],[32,10,33,15]]}
[]
[null,"INCOMETAX 2021-22 SOFTWARE में आपका स्वागत है "]
[null,"करणीय कार्य"]
[null,"यह प्रोग्राम विशेषकर राजस्थान के सभी शिक्षा' विभाग के कर्मचारीगण हेतु सरल,सहज,एंव स्मार्ट तरीके से बनाया गया है"]
[null,1,"GA 55 SHEET"]
[null,null,"दोस्तों सबसे पहले GA55 SHEET में YELLO SHELL में ENTRY करे "]
[null,null,"इसके बाद मार्च माह का वेतन ENTER करे और आपसे संबधित जानकारी का चुनाव करे और आपका GA 55 तैयार है"]
[null,null,"आयकर स्लैब का चयन करे "]
[null,null,"कटौती में GPF,SIP,GPF LOAN,INCOMETAX इत्यादि की entry करे बाकी cell ऑटो जनरेट है BILL NO एंव TV NO MANUAL FEED करे"]
[null,2,"7 PAY MATRIX CHART"]
[null,null,"इस sheet को लॉक किया गया है आप अपना लेवल के अनुसार basic पे देख सकते है !"]
[null,3,"TAX CALCULATION"]
[null,null,"यह sheet भी लॉक है आप OLD TAX REGIME और NEW TAX REGIME में आपके लिए कोनसी BETTER है का चुनाव कर सकते है"]
[null,4,"OLD TAX REGIME "]
[null,null,"इस sheet में आयकर विभाग द्वारा जिस धारा की छूट GA 55 के अलावा है तो DARK cell में entry करे"]
[null,5,"NEW TAX REGIME "]
[null,null,"इस sheet में आयकर विभाग द्वारा 70% प्रकार की छूट नहीं है केवल NPS कर्मचारी अंशदान की छूट ले सकता है "]
[null,6,"PAY SLIP"]
[null,null,"यदि आपने GA55 कम्पलीट भर दिया है तो इसमें माह का चुनाव करके अपनी माहवार वेतन पर्ची print ले सकते है"]
[]
[null,"आपकी सुरक्षा ही मेरी उर्जा है अतः कोविड नियमो का पालन करे",{"$nulls":3},"आप मेरा youtube चैनल भी देख और SUBSCRIBE और LIKE कर सकते है",{"$nulls":5},"https://youtu.be/3yHQVnwH1W0"]
[]
[{"$nulls":3},"दोस्तों यह PROGRAMME आपको कैसा लगा मेरी MAIL ID पर जरुर बताये "]
[{"$nulls":3},"आपका विजय कुमार प्रजापत अध्यापक "]
[{"$nulls":3},"राजकीय उच्च माध्यमिक विद्यालय आलनियावास तह. रियां बड़ी जिला- नागौर "]
[{"$nulls":6},9828120697,null,"कृपया इस नम्बर पर केवल MASSAGE करे CALL नहीं करे"]
[{"$nulls":3},"मेरे प्रेरणास्रोत --- अश्विनीकुमारजी,किशन जी सेन,विष्णुजी शर्मा,मोहम्मद शरीफ जी,परमानन्द जी,हीरालाल जी जाट और आप"]
[{"$nulls":3},"कृपया मेरे अन्य सभी SOFTWARE एंव अन्य शैक्षिक उपयोगी जानकारी हेतु इन LINKS पर जाये",null,null,"http://www.rajsevak.com/VIJAY-KUMAR-PRAJAPAT-SOFTWARE/",null,null,"http://www.ashwinisharma.com/p/vijay-kumar-excel-sheet-expert.html",{"$nulls":3},"http://www.shalasugam.com/vijay-kumar-excel-expert/"]
[]
[]
[{"$nulls":3},"नोट-- यह programe आपकी सुविधा हेतु बनाया गया है एंव GA55 से TALLY करके बनाये औरआयकर विभाग के नियम ही अंतिम होंगे|",{"$nulls":5},"https://rajteacher.net/vijay-kumar-prajapat",{"$nulls":3},"यह software PC,LAPTOP एंव MOBILE पर भी USE कर सकते है मोबाइल में WPS जैसे APP हो एंव EDIT OPTION में प्रत्येक cell में entry करे"]
[]
[null,"KEEP YOUR FACE ALWAYS IN SUNSHINE",{"$nulls":5},"ANY SUGGESTION AND QUERY PLS CONTACT ME",null,null,"MAIL ID-  gupskalani@gmail.com"]

{"sheet":"GA55","index":1,"n_rows":65,"n_cols":115,"rows_kept":65,"merged":[[0,0,4,0],[0,1,0,18],[0,19,0,21],[0,49,4,49],[0,50,5,50],[1,1,1,18],[1,19,1,21],[1,23,1,24],[2,1,2,7],[2,8,2,9],[2,10,2,18],[2,19,2,21],[2,23,3,24],[3,1,3,14],[3,16,3,18],[3,19,3,21],[4,1,4,10],[4,12,4,21],[4,23,5,24],[5,1,5,10],[5,12,5,21],[6,1,6,24],[7,1,7,17],[7,18,7,21],[7,22,7,24],[8,1,8,2],[8,3,8,7],[8,9,8,12],[8,14,8,17],[8,18,8,21],[8,22,8,24],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,10],[9,12,9,19],[9,20,9,21],[9,22,9,24],[10,1,10,2],[10,3,10,6],[10,7,10,8],[10,9,10,11],[10,12,10,14],[10,15,10,18],[10,19,10,21],[10,22,10,24],[16,35,16,40],[17,35,17,36],[18,35,18,36],[19,35,19,36],[20,35,20,36],[21,35,21,36],[35,2,35,6],[35,19,35,23],[36,2,36,6],[36,9,36,15],[36,19,36,23],[37,2,37,4]]}
[null,"आप आयकर गणना प्रपत्र पुराना लेना चाहते है तो DROPDOWN MENU में OLD अथवा नए के लिए new का चयन करे |",{"$nulls":20},"OLD","TAX",{"$f":"IF(W1=\"OLD\",'OLD TAX REGIME'!M55,'NEW TAX REGIME'!M56)","v":43921},{"$nulls":25},"SIP,SIL,GPF,LIC,  GIL,IT की कटोती MANUAL मार्च21 से करे"]
[null,"क्या आप 01.01.2004 के बाद नियुक्त है तो DROPDOWN मेनू में YES अथवा NO का चयन करे|",{"$nulls":20},"YES","HRA",{"$nulls":4},{"$f":"IF(W2=\"yes\",AB13,IF(W2=\"no\",AC16))","v":6119},{"$nulls":9},1,{"$f":"W9","v":52300},31,{"$f":"AN2/AO2*15","v":25306.451612903224},{"$f":"ROUND(AP2,0)","v":25306},{"$f":"ROUND(AQ2*17/100,0)","v":4302}]
[null,"कर्मचारी का राज्य सेवा में प्रकार",{"$nulls":6},"REGULAR",null,"क्या आपको बोनस मिला है तो YES अथवा NO का चयन करे",{"$nulls":11},"YES",{"$nulls":8},{"v":0.08,"d":"8%"},{"$nulls":6},2,{"$f":"D14","v":52300},29,{"$f":"AN3/AO3*15","v":27051.724137931036},{"$f":"ROUND(AP3,0)","v":27052},{"$f":"ROUND(AQ3*17/100,0)","v":4599}]
[null,"क्या आपको समर्पित अवकाश मिला है तो YES अथवा NO का चयन करे",{"$nulls":13},"NO","किस माह में उठाया",{"$nulls":5},10,{"$nulls":5},"YES",null,",uih,l",{"v":0.16,"d":"16%"},{"$nulls":6},3,{"$f":"D15","v":52300},31,25306.451612903224,25306,4302,{"$nulls":3},"OLD"]
[null,"क्या आपको विशेषयोग्यजन कर्मचारी भत्ता मिलता है|",{"$nulls":9},"NO","क्या आपको मार्च2020 का एरियर भुगतान इस वर्ष मिला है",{"$nulls":9},"YES",{"v":0.09,"d":"9%"},{"$nulls":6},"thih,Q",{"$nulls":7},4,{"$f":"D16","v":52300},30,26150,26150,4446,{"$nulls":3},"NEW"]
[null,"NPS के कर्मचारी RGHS में स्वेच्छिक कटोती करवाना चाहते है ",{"$nulls":9},"YES","क्या आपको HRA की छूट देय है  ",{"$nulls":9},"YES",{"$nulls":15},0,{"$nulls":4},0]
[null,"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR",{"$nulls":26},"REGULAR","YES",{"$nulls":8},5,{"$f":"D17","v":53900},31,26080.645161290322,26081,4434,{"$nulls":13},"OLD TAX REGIME"]
[null,"वेतन एंव कर निर्धारण वर्ष 2021-22",{"$nulls":16},"आयकर स्लैब का चयन",{"$nulls":3},"OLD TAX REGIME",{"$nulls":5},"PROBATION","NO","YES","surender",2,{"$nulls":5},6,53900,30,26950,26950,4582,{"$nulls":13},"NEW TAX REGIME"]
[null,"नाम कर्मचारी",null,"VIJAY KUMAR PRAJAPAT",{"$nulls":4},"पद","lecturer",{"$nulls":3},"पेन न","QYPP0000J",{"$nulls":3},"Basic Pay (IN MARCH)",{"$nulls":3},52300,{"$nulls":6},{"$f":"IF(AC4>=\"YES\",(D13+E13)*10/100)","v":6119.1},"NO",{"$nulls":7},7,53900,31,26080.645161290322,26081,{"$f":"ROUND(AQ9*31/100,0)","v":8085},{"$nulls":9},"(    OLD TAX REGIME    )"]
[null,"राज्य बीमा",null,0,null,"जीपीएफ/एनपीएस",null,111111111111,{"$nulls":3},"बैंक ब्रांच","STATE BANK OF INDIA RIYAN BARI",{"$nulls":7},"Bank A/c",null,61000000000,{"$nulls":3},{"$f":"ROUND(W9-(W9*0.03),2)","v":50731},{"$f":"ROUND(AA10,-2)","v":50700},{"$nulls":3},{"$f":"VLOOKUP(L5,B13:E24,3,0)","v":{"$error":"#N/A"}},{"$nulls":6},8,53900,31,26080.645161290322,26081,{"$f":"ROUND(AQ10*31/100,0)","v":8085},{"$nulls":9},"(    NEW TAX REGIME        )"]
[null,"आधार नम्बर",null,333333333333,{"$nulls":3},"टेन नम्बर",null,"JDHG00000H",null,null,"मोबाइल नम्बर",null,null,0,{"$nulls":3},"EMPLOYEE ID",null,null,"RJNA0000000000",{"$nulls":15},9,{"$f":"D20","v":53900},30,{"$f":"AN11/AO11*15","v":26950},{"$f":"ROUND(AP11,0)","v":26950},8355,{"$nulls":12},{"$f":"IF(W2=\"YES\",\" \",\" \")","v":" "}]
[null,"S. NO.","Months & Year","Basic pay","Dearness allowance","H.R.A.","Handicaped allowance","Washing allowance","other","other1","Gross pay","NPS","GPF","GPF Loan","RPMF/RGHS","SIP","SIL","LIC","GIS","GPF04","Income tax","Total ded.","NET PAY","Bill No.","TV. No.",{"$nulls":3},{"$f":"AA10/31*16","v":26183.74193548387},null,null,{"$f":"AF10/31*15","v":{"$error":"#N/A"}},{"$f":"ROUND(AF12,0)","v":{"$error":"#N/A"}},{"$f":"AF10/31*0","v":{"$error":"#N/A"}},{"$nulls":4},10,53900,31,26080.645161290322,26081,8085]
[null,1,"2021-03-01",{"$f":"BA13","v":52300},{"$f":"IF(I3=\"REGULAR\",ROUND((D13*17/100),0),0)","v":8891},{"$f":"IF($I$3=\"REGULAR\",ROUND((D13*8%),0),0)","v":4184},{"$f":"IF($L$5=\"yes\",600,\"\")","v":""},0," "," ",{"$f":"SUM(D13:J13)","v":65375},{"$f":"IF($W$2=\"yes\",AB13,IF($W$2=\"no\",\"  \"))","v":6119},0,0,{"$f":"IF($W$2=\"no\",$AJ$26,\"  \")","v":"  "},7000,0,1070,null,null,0,{"$f":"SUM(L13:U13)","v":14189},{"$f":"K13-V13","v":51186},"111/1-4-20","45/4-4-2020",null,{"$f":"K13","v":65375},{"$f":"ROUND(((D13+E13)*10/100),0)","v":6119},{"$f":"(AA10/31)*5","v":8182.41935483871},{"$f":"ROUND(AC13,0)","v":8182},"TEACHER",3,"B",null,{"$f":"IF(W2=\"YES\",\" \",AJ25)","v":" "},{"$nulls":3},11,53900,30,26950,26950,8355,{"$nulls":8},{"$f":"W9","v":52300}]
[null,2,"2021-04-01",{"$f":"BA14","v":52300},{"$f":"IF($I$3=\"REGULAR\",ROUND((D14*17/100),0),0)","v":8891},{"$f":"IF($I$3=\"REGULAR\",ROUND((D14*8%),0),0)","v":4184},{"$f":"IF($L$5=\"yes\",600,\"\")","v":""},{"$nulls":3},{"$f":"SUM(D14:J14)","v":65375},{"$f":"IF($W$2=\"yes\",AB14,IF($W$2=\"no\",\"  \"))","v":6119},{"$f":"M13","v":0},null,{"$f":"IF($W$2=\"no\",$AJ$26,\"  \")","v":"  "},{"$f":"P13","v":7000},{"$f":"Q13","v":0},1070,220,null,{"$f":"U13","v":0},{"$f":"SUM(L14:U14)","v":14409},{"$f":"K14-V14","v":50966},{"$nulls":3},{"$f":"K14","v":65375},{"$f":"ROUND(((D14+E14)*10/100),0)","v":6119},{"$f":"(AA10/31)*3","v":4909.451612903225},{"$f":"ROUND(AC14,0)","v":4909},"SR.TEACHER",3,"B",null,{"$f":"IF($W$3=\"YES\",\" \",AJ26)","v":" "},{"$nulls":3},12,53900,31,26080.645161290322,26081,8085,{"$nulls":8},{"$f":"W9","v":52300}]
[null,3,"2021-05-01",{"$f":"BA15","v":52300},{"$f":"IF($I$3=\"REGULAR\",ROUND((D15*17/100),0),0)","v":8891},4184,"",{"$nulls":3},65375,6119,0,null,"  ",7000,0,1070,null,null,0,{"$f":"SUM(L15:U15)","v":14189},{"$f":"K15-V15","v":51186},{"$nulls":3},65375,6119,{"$f":"(AA10/31)*2","v":3272.967741935484},3273,"LECTURER",5,"A",null,{"$f":"IF(W4=\"YES\",\" \",AJ27)","v":{"v":330,"d":"330.00"}},{"$nulls":17},{"$f":"BA14","v":52300},{"$nulls":23},{"$f":"D16","v":52300}]
[null,4,"2021-06-01",52300,8891,4184,{"$nulls":4},65375,6119,0,null,"  ",7000,0,1070,null,null,0,14189,51186,{"$nulls":3},65375,6119,null,"A","HEADMASTER",5,"A",null,{"$f":"IF(W5=\"YES\",\" \",AJ28)","v":" "},{"$nulls":17},{"$f":"BA15","v":52300},{"$nulls":23},{"$f":"D17","v":53900},{"$f":"BY16*31/100","v":16709},{"$f":"BY16*28/100","v":15092},{"$f":"BZ16-CA16","v":1617},{"$f":"CB16*10/100","v":161.7},{"$f":"CB16-CC16","v":1455.3}]
[null,5,"2021-07-01",{"$f":"BA17","v":53900},{"$f":"IF($I$3=\"REGULAR\",ROUND((D17*28/100),0),0)","v":15092},4312,"",{"$nulls":3},73304,6899,0,null,{"$f":"IF($W$2=\"no\",$AJ$26,IF($L$6=\"yes\",$AJ$27,\"  \"))","v":330},7000,{"$f":"Q16","v":0},{"$f":"R16","v":1070},null,null,0,15299,58005,{"$nulls":3},73304,6899,null,"A","PRINCIPAL",5,"A",null,{"$f":"IF(W7=\"YES\",\" \",AJ29)","v":{"v":0,"d":"0.00"}},"RPMF RATES",{"$nulls":16},{"$f":"IF(I3=\"REGULAR\",ROUND(BA16+(BA16*0.03),-2),W9)","v":53900},{"$nulls":23},{"$f":"D18","v":53900},{"$f":"BY17*31/100","v":16709},{"$f":"BY17*28/100","v":15092},{"$f":"BZ17-CA17","v":1617},{"$f":"CB17*10/100","v":161.7},{"$f":"CB17-CC17","v":1455.3},{"$nulls":32},{"$f":"F18-F17","v":539}]
[null,6,"2021-08-01",53900,{"$f":"IF($I$3=\"REGULAR\",ROUND((D18*28/100),0),0)","v":15092},{"$f":"IF($I$3=\"REGULAR\",ROUND((D18*$X$5),0),0)","v":4851},"",{"$nulls":3},73843,6899,0,null,330,7000,0,1070,null,null,{"$f":"U17","v":0},15299,58544,{"$nulls":3},73843,6899,null,"B","PRABODHAK",3,"B",null,{"$f":"IF(W8=\"YES\",\" \",AJ31)","v":{"v":0,"d":"0.00"}},"PAY RANGE",null,"2017-10-01","2017-11-01","2019-04-01","2020-04-01",{"$nulls":11},{"$f":"BA17","v":53900},{"$nulls":23},53900,16709,15092,1617,161.7,1455.3]
[null,7,"2021-09-01",53900,15092,4851,"",{"$nulls":3},73843,6899,0,null,330,7000,0,1070,null,null,0,15299,58544,null,null,{"$f":"IF($AE$32=\"A\",(AA19/30*2),IF($AE$32=\"B\",(AA19/30*1),IF($AE$32=\"C\",(AA19/30*0))))","v":{"$error":"#N/A"}},{"$f":"D19+E19+F19","v":73843},6899,null,"B","LAB. ASSISTANT",3,"B",null,{"v":0,"d":"0.00"},"UP TO   18000",null,{"v":205,"d":"205.00"},{"v":210,"d":"210.00"},{"v":242,"d":"242.00"},{"v":265,"d":"265.00"},242,265,{"v":135,"d":"135.00"},{"$nulls":8},{"$f":"BA18","v":53900},{"$nulls":23},53900,16709,15092,1617,161.7,1455.3]
[null,8,"2021-10-01",53900,{"$f":"IF($I$3=\"REGULAR\",ROUND((D20*31/100),0),0)","v":16709},4851,"",{"$nulls":3},{"$f":"SUM(D20:J20)","v":75460},7061,0,null,330,{"$f":"P19","v":7000},0,1070,null,null,0,{"$f":"SUM(L20:U20)","v":15461},59999,null,null,{"$f":"IF($AE$32=\"A\",(AA20/31*2),IF($AE$32=\"B\",(AA20/31*1),IF($AE$32=\"C\",(AA20/31*0))))","v":{"$error":"#N/A"}},75460,7061,null,"B","LIBRARIAN",3,"B",null,{"v":0,"d":"0.00"},"18001 TO 33500",null,{"v":341,"d":"341.00"},{"v":349,"d":"349.00"},{"v":402,"d":"402.00"},{"v":440,"d":"440.00"},402,440,{"v":220,"d":"220.00"},{"$nulls":8},53900,{"$nulls":26},{"$f":"SUM(CB16:CB19)","v":6468},{"$f":"ROUND(SUM(CC16:CC19),0)","v":647},{"$f":"ROUND(SUM(CD16:CD19),0)","v":5821},1412,{"$f":"CD20-CE20","v":4409}]
[null,9,"2021-11-01",53900,{"$f":"IF($I$3=\"REGULAR\",ROUND((D21*31/100),0),0)","v":16709},4851,"",{"$nulls":3},75460,7061,0,null,330,7000,{"$f":"Q20","v":0},1070,null,null,0,15461,59999,null,null,{"$f":"IF($AE$32=\"A\",(AA21/30*2),IF($AE$32=\"B\",(AA21/30*1),IF($AE$32=\"C\",(AA21/30*0))))","v":{"$error":"#N/A"}},75460,7061,null,"B","A.A.O.",3,"B",null,{"v":0,"d":"0.00"},"33501 TO 54000",null,{"v":511,"d":"511.00"},{"v":522,"d":"522.00"},{"v":602,"d":"602.00"},{"v":658,"d":"658.00"},602,658,{"v":330,"d":"330.00"},{"$nulls":8},53900]
[null,10,"2021-12-01",53900,16709,4851,"",{"$nulls":3},75460,7061,0,null,330,{"$f":"P21","v":7000},0,1070,null,null,0,15461,59999,null,null,{"$error":"#N/A"},75460,7061,null,"B","SENIOR ASSISTANT",3,"B",null,{"v":0,"d":"0.00"},"54001 & ABOVE",null,{"v":680,"d":"680.00"},{"v":695,"d":"695.00"},{"v":800,"d":"800.00"},{"v":875,"d":"875.00"},800,875,{"v":440,"d":"440.00"},{"$nulls":8},53900]
[null,11,"2022-01-01",53900,16709,4851,"",{"$nulls":3},75460,7061,0,null,330,{"$f":"P21","v":7000},0,1070,null,null,0,15461,59999,null,null,{"$error":"#N/A"},75460,7061,null,"C","JUNIOR ASSISTANT",2,"C",null,{"v":0,"d":"0.00"},{"$nulls":17},53900]
[null,12,"2022-02-01",53900,16709,4851,"",{"$nulls":3},75460,7061,0,null,330,{"$f":"P23","v":7000},0,{"$f":"R23","v":1070},null,null,0,15461,59999,null,null,{"$f":"IF($AE$32=\"A\",(AA24/28*2),IF($AE$32=\"B\",(AA24/28*1),IF($AE$32=\"C\",(AA24/28*0))))","v":{"$error":"#N/A"}},75460,7061,null,null,"OFFICE ASSISTANT",{"$nulls":21},53900]
[null,13,"SURRENDER",{"$f":"IF(P4=\"yes\",AN26,IF(P4>=\"No\",0))","v":0},{"$f":"IF(P4=\"YES\",VLOOKUP(W4,SDA,6,0),0)","v":0},0,{"$nulls":4},0,0,{"$nulls":9},0,0,{"$nulls":4},0,{"$nulls":7},{"$f":"IF(18000>$W$9,AP19,IF(33500>$W$9,AP20,IF(54000>$W$9,AP21,IF(,54001<$W$9,AP22))))","v":{"v":602,"d":"602.00"}},{"$f":"ISNUMBER(AJ25)","v":true}]
[null,14,"D.A. (JULY-SEP21)",null,{"$f":"CB20","v":6468},{"$nulls":5},{"$f":"SUM(D26:J26)","v":6468},{"$f":"IF($W$2=\"yes\",AB26,IF($W$2=\"no\",\" \"))","v":647},{"$f":"IF(W2=\"no\",CB20,\" \")","v":" "},{"$nulls":6},{"$f":"IF(W2=\"YES\",CD20,0)","v":5821},null,6468,0,{"$nulls":4},647,{"$nulls":7},{"$f":"IF(18000>W9,AQ19,IF(33500>W9,AQ20,IF(54000>W9,AQ21,IF(,54000>W9,AQ22))))","v":658},{"$f":"ISNUMBER(AJ26)","v":true},null,null,{"$f":"VLOOKUP(W4,AM2:AQ15,5,0)","v":26081}]
[null,15,"D.A. AREAR",null,{"$f":"IF($I$3=\"REGULAR\",ROUND((D27*26/100),0),0)","v":0},{"$nulls":5},0,0,{"$f":"IF(W2=\"yes\",\" \",K27)","v":" "},{"$nulls":8},0,0,{"$nulls":4},0,null,{"$f":"W9*5/100*6","v":15690},null,{"$f":"ROUND(AC13,0)","v":8182},{"$f":"ROUND(AC14,0)","v":4909},{"$f":"ROUND(AC15,0)","v":3273},null,{"$f":"IF(18000>W9,AR19,IF(33500>W9,AR20,IF(54000>W9,AR21,IF(,54000<W9,AR22))))","v":330}]
[null,16,"BONUS",{"$f":"AD33","v":6774},{"$nulls":6},6774,null,{"$f":"IF(W2=\"NO\",BX29,0)","v":0},{"$nulls":6},{"$f":"IF(W2=\"YES\",BX29,0)","v":3387},null,3387,3387,{"$nulls":6},{"$f":"W9*5/100*2","v":5230},{"$nulls":16},{"$f":"K32+L32","v":990490}]
[null,17,"SALARY ARREAR",null,null,{"$f":"DK17","v":539},{"$nulls":4},{"$f":"SUM(D29:J29)","v":539},{"$nulls":10},0,539,{"$nulls":8},"PRINCIPAL","A",5,{"$nulls":41},{"$f":"K28/2","v":3387}]
[null,18,"SALARY ARREAR",0]
[null,19,"2020-03-01",{"$f":"IF(W5=\"yes\",ROUND(AC12,0),0)","v":26184},{"$f":"ROUND((D31*17/100),0)","v":4451},{"$f":"ROUND((D31*8/100),0)","v":2095},{"$nulls":4},32730,3064,{"$nulls":9},3064,29666,{"$nulls":4},3064,{"$f":"SUM(U25:U31)","v":0},null,null,"HEAD MASTER ","A",5]
[null,null,"TOTAL",{"$f":"SUM(D13:D31)","v":673358},{"$f":"SUM(E13:E31)","v":175304},57639,0,0,0,0,906301,{"$f":"SUM(L13:L31)","v":84189},0,0,{"$f":"SUM(O13:O31)","v":2640},84000,0,12840,220,9208,{"$f":"SUM(U13:U31)","v":0},{"$f":"SUM(V13:V31)","v":193097},{"$f":"SUM(W13:W31)","v":713204},{"$nulls":6},{"$f":"IF(AE32=\"A\",(W9/31*5),IF(AE32=\"B\",(W9/31*3),IF(AE32=\"C\",(W9/31*2))))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J9,AF29:AH67,2,0)","v":{"$error":"#N/A"}},"LECTURER (School Edu.)","A",5]
[{"$nulls":27},{"$f":"AD33-AC33","v":{"v":5080,"d":"5080.00"}},{"$f":"ROUND(AD33*25/100,0)","v":1694},{"$f":"IF(W3=\"YES\",6774,IF(W3=\"NO\",\" \"))","v":{"v":6774,"d":"6774.00"}},null,"SENOIR TEACHER (II Gr.)","B",3]
[{"$nulls":28},{"$f":"ROUND(AD33*20/100,0)","v":1355},{"$f":"IF(AE32=\"A\",(AA19/31*2),IF(AE32=\"B\",(AA19/31*1),IF(AE32=\"C\",(AA19/31*0))))","v":{"$error":"#N/A"}},null,"SENOIR TEACHER (Ele.HM)","B",3]
[{"$nulls":28},{"$f":"AC33-AC34","v":339},null,null,"TEACHER (III Gr.) Level 2","B",3]
[null,null,"Signature of Employee",{"$nulls":16},"Signature of DDO",{"$nulls":11},"TEACHER (III Gr.) Level 1","B",3]
[null,null,{"$f":"D9","v":"VIJAY KUMAR PRAJAPAT"},{"$nulls":6},"vijay prajapat excel programmer9828120697",{"$nulls":21},"PET (I Gr.)","A",5]
[{"$nulls":31},"PET (II Gr.)","B",3]
[{"$nulls":31},"PET ( III Gr.)","B",3]
[{"$nulls":31}," SPECIAL TEACHER (III Gr.) Level 1","B",3]
[{"$nulls":31}," SPECIAL TEACHER (III Gr.) Level 2","B",3]
[{"$nulls":31},"LIBRARIAN ( I Gr.)","A",5]
[{"$nulls":31},"LIBRARIAN ( II Gr.)","B",3]
[{"$nulls":31},"LIBRARIAN ( III Gr.)","B",3]
[{"$nulls":31},"LAB. ASSISTANT (II Gr.)","B",3]
[{"$nulls":31},"LAB. ASSISTANT (II Gr.)","B",3]
[{"$nulls":31},"LAB BOY","C",2]
[{"$nulls":31},"COACH","A",5]
[{"$nulls":31},"A.A.O.","B",3]
[{"$nulls":31},"SENIOR ASSISTANT(UDC)","B",3]
[{"$nulls":31},"JUNIOR ASSISTANT (LDC)","B",3]
[{"$nulls":31},"OFFICE ASSISTANT ( PEON )","C",2]
[{"$nulls":31},"PRABODHAK ( III Gr.) LEVEL 1","B",3]
[{"$nulls":31},"PRABODHAK ( III Gr.) LEVEL 2","B",3]
[{"$nulls":31},"PRABODHAK PET.( III Gr.) LEVEL 1","B",3]
[{"$nulls":32},"B",3]
[{"$nulls":32},"C",2]
[{"$nulls":32},"A",5]
[{"$nulls":32},"A",5]
[{"$nulls":32},"B",3]
[{"$nulls":32},"B",3]
[{"$nulls":32},"B",3]
[{"$nulls":32},"A",5]
[{"$nulls":32},"A",5]
[{"$nulls":32},"B",3]

{"sheet":"7pay matrix chart","index":2,"n_rows":48,"n_cols":31,"rows_kept":48,"merged":[[0,0,0,24],[0,25,0,30],[1,0,1,24],[1,25,1,30],[2,0,3,0],[2,1,3,9],[2,10,3,13],[2,14,3,20],[2,21,3,24],[2,25,6,25],[2,26,6,26],[2,27,6,27],[2,28,6,28],[2,29,6,29],[2,30,6,30],[22,23,25,24],[26,21,26,24],[27,21,27,22],[28,21,28,22],[29,21,29,22],[30,21,30,22],[31,21,31,22],[31,25,31,28],[32,21,32,22],[32,25,32,26],[33,21,33,22],[33,25,33,26],[34,21,34,22],[34,25,34,26],[35,21,35,22],[35,25,35,26],[36,21,36,22],[36,25,36,26],[37,20,39,20],[37,21,37,22],[37,25,37,26],[38,21,38,24],[38,25,38,26],[39,21,39,22],[40,19,41,20],[40,21,40,22],[41,21,41,22],[42,18,43,20],[42,21,42,22],[43,21,43,22],[44,17,44,20],[44,21,44,30],[45,16,47,20]]}
["SCHEDULE-1 PART-B RULE NO.5 VI & VII",{"$nulls":24},"SHEDULE IV  (RULE NO. 16"]
["PAY MATRIX OF STATE GOVT. SERVANTS",{"$nulls":24},"FIX REMUNERATION FOR PROBATIONER-TRAINEE"]
["EXISTING R.P. BAND","                                  PB-1                                       5200-20000",{"$nulls":8},"              PB -2                    9300-34800",{"$nulls":3},"                             PB-3                                 15600-39100",{"$nulls":6},"                 PB -4                  37400-67000",{"$nulls":3},"S.NO.","EXITING G.P.","EXITING G.P.NO.","EXITING AMOUNT OF FIXED RENUANERATION","CORRESPONDING LEVEL","FIXED REMUNERATION (WEF 01-01-17)"]
[]
["EXIST.G.P.",1700,1750,1900,2000,2400,2400,2400,2800,2800,3600,4200,4800,5400,5400,6000,6600,6800,7200,7600,8200,8700,8900,9500,10000]
["EXIST.G.P.",2,3,4,5,9,"9A","9B",10,"10A",11,12,14,15,15,16,17,18,19,20,21,22,23,"23A",24]
["LEVELS‏‏‏‏-","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"]
["CELL NO",{"$nulls":24},1,2,3,4,5,6]
[1,17700,17900,18200,19200,20800,21500,22400,26300,28700,33800,37800,44300,53100,56100,60700,67300,71000,75300,79900,88900,123100,129700,145800,148800,1,1700,2,6670,"L-1",12400]
[2,{"$f":"ROUND(B9+(B9*0.03),-2)","v":18200},{"$f":"ROUND(C9+(C9*0.03),-2)","v":18400},{"$f":"ROUND(D9+(D9*0.03),-2)","v":18700},19800,21400,22100,23100,27100,29600,34800,38900,45600,54700,57800,62500,69300,73100,77600,82300,91600,126800,133600,150200,153300,2,1750,3,7000,"L-2",12600]
[3,{"$f":"ROUND(B10+(B10*0.03),-2)","v":18700},19000,19300,20400,22000,22800,23800,27900,30500,35800,40100,47000,56300,59500,64400,71400,75300,79900,84800,94300,130600,137600,154700,157900,3,1900,4,7400,"L-3",12800]
[4,19300,19600,19900,21000,22700,23500,24500,28700,31400,36900,41300,48400,58000,61300,66300,73500,77600,82300,87300,97100,134500,141700,159300,162600,4,2000,5,7790,"L-4",13500]
[5,19900,20200,20500,21600,23400,24200,25200,29600,32300,38000,42500,49900,59700,63100,68300,75700,79900,84800,89900,100000,138500,146000,164100,167500,5,2400,9,7790,"L-5",14600]
[6,20500,20800,21100,22200,24100,24900,26000,30500,33300,39100,43800,51400,61500,65000,70300,78000,82300,87300,92600,103000,142700,150400,169000,172500,6,2400,"9A",8910,"L-6",15100]
[7,21100,21400,21700,22900,24800,25600,26800,31400,34300,40300,45100,52900,63300,67000,72400,80300,84800,89900,95400,106100,147000,154900,174100,177700,7,2400,"9B",8910,"L-7",15700]
[8,21700,22000,22400,23600,25500,26400,27600,32300,35300,41500,46500,54500,65200,69000,74600,82700,87300,92600,98300,109300,151400,159500,179300,183000,8,2800,10,11820,"L-8",18500]
[9,22400,22700,23100,24300,26300,27200,28400,33300,36400,42700,47900,56100,67200,71100,76800,85200,89900,95400,101200,112600,155900,164300,184700,188500,9,2800,"10A",11820,"L-9",20100]
[10,23100,23400,23800,25000,27100,28000,29300,34300,37500,44000,49300,57800,69200,73200,79100,87800,92600,98300,104200,116000,160600,169200,190200,194200,10,3600,11,13200,"L-10",23700]
[11,23800,24100,24500,25800,27900,28800,30200,35300,38600,45300,50800,59500,71300,75400,81500,90400,95400,101200,107300,119500,165400,174300,195900,200000,11,4200,12,14660,"L-11",26500]
[12,24500,24800,25200,26600,28700,29700,31100,36400,39800,46700,52300,61300,73400,77700,83900,93100,98300,104200,110500,123100,170400,179500,201800,206000,12,4800,14,17230,"L-12",31100]
[13,25200,25500,26000,27400,29600,30600,32000,37500,41000,48100,53900,63100,75600,80000,86400,{"$f":"ROUND(Q20+(Q20*0.03),-2)","v":95900},101200,107300,113800,126800,175500,184900,207900,212200,13,5400,15,22180,"L-14",39300]
[14,26000,26300,26800,28200,30500,31500,33000,38600,42200,49500,55500,65000,77900,82400,89000,98800,104200,110500,117200,130600,180800,190400,214100,218600,14,6000,16,24030,"L-15",42500]
[15,26800,27100,27600,29000,31400,32400,34000,39800,43500,51000,57200,67000,80200,84900,91700,101800,107300,113800,120700,134500,186200,196100,null,null,15,6600,17,26670,"L-16",47200]
[16,27600,27900,28400,29900,32300,33400,35000,41000,44800,52500,58900,69000,82600,87400,94500,104900,110500,117200,124300,138500,191800,202000,null,null,16,6800,18,28120,"L-17",49700]
[17,28400,28700,29300,30800,33300,34400,36100,42200,46100,54100,60700,71100,85100,90000,97300,108000,113800,120700,128000,142700,197600,208100,null,null,17,7200,19,29840,"L-18",52800]
[18,29300,29600,30200,31700,34300,35400,37200,43500,47500,55700,62500,73200,87700,92700,100200,111200,117200,124300,131800,147000,203500,{"$nulls":3},18,7600,20,31620,"L-19",56000]
[19,{"$f":"ROUND(B26+(B26*0.03),-2)","v":30200},30500,31100,32700,35300,36500,38300,44800,48900,57400,64400,75400,90300,95500,103200,114500,120700,128000,135800,151400,"GPF RATES",{"$nulls":3},19,8200,21,35180,"L-20",62300]
[20,31100,31400,32000,33700,36400,37600,39400,46100,50400,59100,66300,77700,93000,98400,106300,117900,124300,131800,139900,155900,"RANGE",null,"2017-10-01","2018-03-01",20,8700,22,48710,"L-21",86200]
[21,32000,32300,33000,34700,37500,38700,40600,47500,51900,60900,68300,80000,95800,101400,109500,121400,128000,135800,144100,160600,"UPTO 23100",null,500,14500,21,8900,23,51350,"L-22",90800]
[22,33000,33300,34000,35700,38600,39900,41800,48900,53500,62700,70300,82400,98700,104400,112800,125000,131800,139900,148400,165400,"23101 TO 28500",null,650,1625,22,9500,"23A",54120,"L-23",102100]
[23,34000,34300,35000,36800,39800,41100,43100,50400,55100,64600,72400,84900,101700,107500,116200,128800,135800,144100,152900,170400,"28501 TO 38500",null,1100,2100,23,10000,24,57820,"L-24",104200]
[24,35000,35300,36100,37900,41000,42300,44400,51900,56800,66500,74600,87400,104800,110700,119700,132700,139900,148400,157500,175500,"38501 TO 51500",null,1450,2850,"SI PREMIUM FROM SALARY"]
[25,36100,36400,37200,39000,42200,43600,45700,53500,58500,68500,76800,90000,107900,114000,123300,136700,144100,152900,162200,180800,"51501 TO 62000",null,2100,3575,"PAY RANGE",null,"2018-03-01","2020-03-01"]
[26,37200,37500,38300,40200,43500,44900,47100,55100,60300,70600,79100,92700,111100,117400,127000,140800,148400,157500,167100,186200,"62001 TO 72000",null,3300,4200,"UPTO 22000",null,500,800]
[27,38300,38600,39400,41400,44800,46200,48500,56800,62100,72700,81500,95500,114400,120900,130800,145000,152900,162200,172100,191800,"72001 TO 80000",null,4100,4800,"22001 TO 28500",null,700,1200]
[28,39400,39800,40600,42600,46100,47600,50000,58500,64000,74900,83900,98400,117800,124500,134700,149400,157500,167100,177300,197600,"80001 TO 116000",null,5200,6150,"28501TO 46500",null,1300,2200]
[29,40600,41000,41800,43900,47500,49000,51500,60300,65900,{"$f":"ROUND(K36+(K36*0.03),-2)","v":77100},86400,101400,121300,128200,138700,153900,{"$f":"ROUND(R36+(R36*0.03),-2)","v":162200},172100,182600,203500,"116001 TO 16700",null,5700,8900,"46501 TO 72000",null,1800,3000]
[30,41800,42200,43100,45200,48900,50500,53000,62100,67900,79400,89000,104400,124900,132000,142900,158500,167100,177300,188100,null,"ABOVE 116700",null,6200,10500,"ABOVE 72000",null,3000,5000]
[31,43100,43500,44400,46600,50400,52000,54600,64000,69900,81800,91700,107500,128600,136000,147200,163300,172100,182600,193700,null,"RPMF RATES",{"$nulls":3},"MAXIMUM",null,4000,7000]
[32,44400,44800,45700,48000,51900,53600,56200,65900,72000,84300,94500,110700,132500,140100,151600,168200,177300,188100,199500,null,"PAY RANGE",null,"2017-10-01","2017-11-01","2018-04-01","2018-10-30","2019-04-01","2020-04-01"]
[33,45700,46100,47100,49400,53500,55200,57900,67900,74200,86800,97300,114000,136500,144300,156100,173200,182600,193700,null,null,"UP TO   18000",null,205,210,219,228,242,265]
[34,47100,47500,48500,50900,55100,56900,59600,69900,76400,89400,100200,117400,140600,148600,160800,178400,188100,199500,null,null,"18001 TO 33500",null,341,349,364,379,402,440]
[35,{"$f":"ROUND(B42+(B42*0.03),-2)","v":48500},48900,50000,52400,56800,58600,61400,72000,78700,92100,103200,120900,144800,153100,165600,183800,193700,{"$nulls":3},"33501 TO 54000",null,511,522,545,568,602,658]
[36,50000,50400,51500,54000,58500,60400,63200,74200,81100,94900,106300,124500,149100,157700,170600,189300,199500,{"$nulls":3},"54001 & ABOVE",null,680,695,725,755,800,875]
[37,51500,51900,53000,55600,60300,62200,65100,76400,83500,97700,109500,128200,153600,162400,175700,195000,{"$nulls":4},"D.A. RATES"]
[38,53000,53500,54600,57300,62100,64100,67100,78700,86000,100600,112800,132000,158200,167300,181000,"             VIJAY KUMAR PRAJAPAT                    GSSS ALNIYAWAS GMAIL ID-gupskalani@gmail.com",{"$nulls":4},"FROM","2017-01-01","2017-07-01","2018-01-01","2018-07-01","2019-01-01","2019-07-01","2021-07-01","2020-07-01","2021-01-01"]
[39,54600,55100,56200,59000,64000,66000,69100,81100,88600,103600,116200,136000,162900,172300,186400,{"$nulls":5},"RATE",{"v":0.04,"d":"4.%"},{"v":0.05,"d":"5.%"},{"v":0.07,"d":"7.%"},{"v":0.09,"d":"9.%"},{"v":0.12,"d":"12.%"},{"v":0.17,"d":"17.%"},{"v":0.28,"d":"28.%"}]
[40,{"$f":"ROUND(B47+(B47*0.03),-2)","v":56200},56800,57900,60800,65900,68000,71200,83500,91300,106700,119700,140100,167800,177500,192000,{"$nulls":5},"GPF ","2017-06-01","2017-09-01","2018-02-01","2018-08-01","2019-02-01","2020-02-01"]

{"sheet":"TAX CALCULATION","index":3,"n_rows":28,"n_cols":13,"rows_kept":28,"merged":[[0,0,0,1],[0,3,0,6],[0,9,0,11],[1,3,1,4],[1,5,1,6],[14,0,16,1],[15,3,15,6],[16,5,16,6],[17,3,17,6]]}
["ENTER DATA IN YELLOW TAB",null,null,"TAX CACULATION",{"$nulls":5},"TAX SLAB ( YEAR 2021-22)"]
["ANNUAL GROSS SALARY",{"$f":"'GA55'!K32","v":906301},null,"OLD TAX REGIME",null,"NEW TAX REGIME  ( OPTIONAL)",{"$nulls":3},"SLAB","OPTIONAL","EXITING"]
["STANDARD DEDUCTION",50000,null,"SLAB AMOUNT (OLD)","TAX","SLAB AMOUNT (NEW)","TAX",{"$nulls":3},"NEW","OLD"]
["HRA",0,null,{"$f":"IF($B$13>250000,250000,$B$13)","v":250000},{"$f":"D4*L4","v":0},{"$f":"IF(B14>250000,250000,D13)","v":250000},{"$f":"F4*K4","v":0},null,null,"0-250000",{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
["PT AND ENTERTAINMENT ALLOWANCE",544,null,{"$f":"IF($B$13>500000,250000,$B$13-D4)","v":250000},{"$f":"IF(B13<=500000,0,(D5*L5))","v":12500},{"$f":"IF($B$14>500000,250000,($B$14-F4))","v":250000},{"$f":"IF(B14<=500000,0,F5*K5)","v":12500},null,null,"250001-500000",{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
["NPS",{"$f":"'GA55'!L32","v":84189},null,{"$f":"IF($B$13>750000,250000,$B$13-D5-D4)","v":121568},{"$f":"ROUND(D6*L6,0)","v":24314},{"$f":"IF($B$14>750000,250000,($B$14-F5-F4))","v":250000},{"$f":"ROUND(F6*K6,0)","v":25000},null,null,"500001-750000",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"}]
["HOM E LOAN ITEREST",null,null,{"$f":"IF($B$13>1000000,250000,$B$13-D6-D5-D4)","v":0},{"$f":"ROUND(D7*L7,0)","v":0},{"$f":"IF($B$14>1000000,250000,($B$14-F5-F6-F4))","v":72112},{"$f":"ROUND(F7*K7,0)","v":10817},null,null,"750001-1000000",{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"}]
["DEDUCTION OG US 80C",150000,null,{"$f":"IF($B$13>1250000,250000,$B$13-D7-D6-D5-D4)","v":0},0,{"$f":"IF($B$14>1250000,250000,($B$14-F6-F7-F5-F4))","v":0},0,null,null,"1000001-1250000",{"v":0.2,"d":"20%"},{"v":0.3,"d":"30%"}]
["HEALTH  INSURANCE US 80D",null,null,{"$f":"IF($B$13>1500000,250000,$B$13-D8-D7-D6-D5-D4)","v":0},0,{"$f":"IF($B$14>1250000,250000,($B$14-F7-F8-F6-F5-F4))","v":0},0,null,null,"1250001-1500000",{"v":0.25,"d":"25%"},{"v":0.3,"d":"30%"}]
["SAVING BANK INTEREST",0,null,{"$f":"IF($B$13>1500000,$B$13-1500000,0)","v":0},0,{"$f":"IF($B$14>1500000,$B$14-1500000,0)","v":0},0,null,null,"1500000 & ABOVE",{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
["80U",0]
["TOAL EXEMPTION & DEDUCTION",{"$f":"B3+B4+B5+B6+B7+B8+B9+B10+B11","v":284733},null,"TOTAL",{"$f":"ROUND(SUM(E4:E11),0)","v":36814},null,{"$f":"SUM(G4:G11)","v":48317}]
["TEXABLE INCOME for exiting slab",{"$f":"B2-B12","v":621568},null,"S.& EDU.TAX",{"$f":"ROUND(E12*4/100,0)","v":1473},{"$f":"-D18","v":0},{"$f":"ROUND(G12*4/100,0)","v":1933}]
["In new income tax nps exemption",{"$f":"B2-B6","v":822112},null,{"$f":"SUM(D4:D11)","v":621568},{"$f":"ROUND(E12+E13,0)","v":38287},{"$f":"SUM(F4:F11)","v":822112},{"$f":"ROUND((G12+G13),0)","v":50250}]
["पीले CELL में कटौती लिखे                           ध्यान रहे एक बार NEW TAX REGIME लेने पर आगामी वर्षों में यही रहेगा ",null,null,"TOTAL TAX",{"$f":"ROUND(E14,0)","v":38287},"TOTAL TAX",{"$f":"ROUND(G14,0)","v":50250}]
[{"$nulls":3},"WHICH IS BETTER FOR YOU ?"]
[{"$nulls":3},{"$f":"IF(G15>E15,\"OLD IS BETTER\",\"NEW IS BETTER\")","v":"OLD IS BETTER"},"FOR",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"B2","v":906301},{"$f":"B13-250000","v":371568},null,null,{"$f":"B13","v":621568},250000,{"$f":"H22-I22","v":371568},{"$f":"B2","v":906301},250000,{"$f":"K22-L22","v":656301}]
[{"$nulls":3},{"$f":"SUM(B3:B7)","v":134733},null,null,{"$f":"IF(E5>=12500,\"0\",IF(E5>=12500,(E5-12500)))","v":"0"},{"$f":"J22","v":371568},250000,{"$f":"H23-I23","v":121568},{"$f":"M22","v":656301},250000,{"$f":"K23-L23","v":406301}]
[{"$nulls":3},{"$f":"D22-D23","v":771568},{"$nulls":6},{"$f":"M23","v":406301},250000,156301]
[{"$nulls":3},{"$f":"SUM(B8:B11)","v":150000},{"$nulls":7},250000,-250000]
[{"$nulls":3},{"$f":"D24-D25","v":621568},{"$f":"B13-250000","v":371568}]
[]
[{"$nulls":3},0]

{"sheet":"OLD TAX REGIME","index":4,"n_rows":67,"n_cols":13,"rows_kept":67,"merged":[[0,1,0,12],[1,1,1,9],[1,10,1,12],[2,4,2,6],[2,8,2,9],[2,11,2,12],[3,3,3,4],[3,5,3,7],[3,8,3,9],[3,10,3,12],[4,3,4,10],[5,3,5,10],[6,3,6,10],[7,1,8,1],[7,3,7,9],[7,12,8,12],[8,3,8,9],[9,3,9,10],[10,1,12,1],[10,7,10,8],[10,12,12,12],[11,3,12,4],[11,5,11,6],[11,7,11,8],[12,5,12,6],[12,7,12,8],[13,3,13,10],[14,1,27,1],[14,3,14,10],[15,3,15,4],[15,7,15,9],[15,12,23,12],[16,3,16,4],[16,7,16,9],[17,3,17,4],[17,7,17,9],[18,3,18,4],[18,7,18,9],[19,3,19,4],[19,7,19,9],[20,3,20,4],[20,7,20,9],[21,3,21,4],[21,7,21,9],[22,3,22,4],[22,7,22,9],[23,3,23,4],[23,6,23,9],[24,2,24,11],[25,2,25,10],[26,2,26,10],[27,2,27,10],[28,1,28,12],[29,1,36,1],[29,3,29,10],[30,3,30,10],[31,3,31,10],[32,3,32,10],[33,3,33,10],[34,3,34,10],[35,3,35,10],[36,3,36,10],[37,1,37,10],[38,2,38,10],[39,2,39,10],[40,2,40,10],[41,2,41,7],[41,8,41,10],[42,1,47,1],[42,2,42,6],[42,8,42,10],[43,2,43,6],[43,8,43,10],[44,2,44,6],[44,8,44,10],[45,2,45,6],[45,8,45,10],[46,2,46,6],[46,8,46,10],[47,2,47,6],[47,8,47,10],[48,2,48,7],[48,8,48,10],[49,2,49,10],[50,1,50,10],[51,1,51,10],[52,1,52,10],[53,1,53,10],[54,1,54,10],[55,1,55,12],[56,2,56,4],[56,6,56,8],[56,9,56,10],[56,12,58,12],[57,2,57,4],[57,6,57,8],[57,9,57,10],[58,2,58,4],[58,6,58,8],[58,9,58,10],[59,2,59,4],[59,6,59,8],[59,9,59,10],[60,2,60,4],[60,6,60,8],[60,9,60,10],[60,12,61,12],[61,2,61,4],[61,6,61,8],[61,9,61,10],[62,2,62,10],[63,2,63,10],[64,2,64,10],[66,3,66,5],[66,10,66,12],[69,3,69,5]]}
[null,{"$f":"'GA55'!B7","v":"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR"}]
[null,"आयकर गणना प्रपत्र 2021-22 ( कर निर्धारण वर्ष 2022-23)",{"$nulls":8},"OLD TAX REGIME"]
[null,1,null,"नाम कर्मचारी",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,"पद",{"$f":"'GA55'!J9","v":"lecturer"},null,"PAN NO",{"$f":"'GA55'!O9","v":"QYPP0000J"}]
[{"$nulls":3},"Bank Ac.No.--",null,{"$f":"'GA55'!W10","v":61000000000},null,null,"Name Of Bank :",null,{"$f":"'GA55'!M10","v":"STATE BANK OF INDIA RIYAN BARI"}]
[null,2,null,"कुल वेतन (कर योग्य सुविधाओ सहित NPS सहित )",{"$nulls":7},"Rs.",{"$f":"'GA55'!AU28","v":{"v":990490,"d":"990490.00"}}]
[null,3,null,"ग्रह किराया धारा 10(13-I) के अंतर्गतएंव धारा 10(14) के अंतर्गतअन्यभत्ते जो करमुक्त हो",{"$nulls":7},"Rs.",{"$f":"IF('GA55'!W6=\"YES\",'GA55'!F32,0)","v":{"v":57639,"d":"57639.00"}}]
[null,4,null,"शेष (2-3) -WITH EXEMPT STANDARD DEDUCTION MAX. 50000",{"$nulls":7},"Rs.",{"$f":"M5-M6-50000","v":{"v":882851,"d":"882851.00"}}]
[null,5,null,"(i) मनोरंजन भत्ता धारा 16(i) के अंतर्गत ( अधिकतम सीमा रू 5000 )",{"$nulls":6},{"v":0,"d":"0.00"},"Rs."]
[{"$nulls":3},"(ii)  व्यवसाय कर धारा 16(ii) के अंतर्गत ( अधिकतम सीमा रू 5000 )",{"$nulls":6},{"v":0,"d":"0.00"},"Rs."]
[null,6,null,"शेष (4-5) ",{"$nulls":7},"Rs.",{"$f":"M7-K8-K9","v":{"v":882851,"d":"882851.00"}}]
[null,7,null,"(अ) ग्रह सम्पति से आय (1) स्वंय के उपयोग में - शून्य",{"$nulls":5},"(2) प्राप्त किराया रू",null,"Rs."]
[{"$nulls":3},"(ब) घटाए",null,"किराये का 30%",null,"ग्रह ऋण पर ब्याज",null,"गृहकर","योग 7 (ब)","Rs."]
[{"$nulls":5},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"$f":"F13+H13+I13+J13+G13","v":{"v":0,"d":"0.00"}},"Rs."]
[{"$nulls":3},"कुल सकल आय",{"$nulls":7},"Rs.",{"$f":"M10-K13","v":{"v":882851,"d":"882851.00"}}]
[null,8,"(A)","Chapter VI A Deductions( max 150000) ",{"$nulls":7},"Rs."]
[null,null,"(i)","GPF/GPF04",null,{"$f":"IF('GA55'!W2=\"YES\",'GA55'!T32,'GA55'!M32)","v":{"v":9208,"d":"9208.00"}},"(x)","FIXED DEPOSIT 5 YEAR",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(ii)","SI",null,{"$f":"'GA55'!P32","v":{"v":84000,"d":"84000.00"}},"(xi)","TUSION FEES",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(iii)","LIC ( from salary)",null,{"$f":"'GA55'!R32","v":{"v":12840,"d":"12840.00"}},"(xii)","NPS CONTRIBUTION ",null,null,{"$f":"M26-M27","v":{"v":84189,"d":"84189.00"}},"Rs."]
[null,null,"(iv)","LIC ( by Self)",null,{"v":26000,"d":"26000.00"},"(xiii)","PENSION PLAN (US 80CCC)",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(v)","PPF",null,{"v":0,"d":"0.00"},"(xiv)","DEFFERED ANNUTY",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(vi)","PLI",null,{"v":0,"d":"0.00"},"(xv)","ULIP",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(vii)","NSC",null,{"v":0,"d":"0.00"},"(xvi)","GIS",null,null,{"$f":"'GA55'!S32","v":{"v":220,"d":"220.00"}},"Rs."]
[null,null,"(viii)","HBA Premium",null,{"v":0,"d":"0.00"},"(xvii)","सुकन्या समृद्धि योजना",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(ix)","NSS",null,{"v":0,"d":"0.00"},"Total( I to xvii)",{"$nulls":3},{"$f":"F16+F17+F18+F19+F21+F20+F22+F23+F24+K16+K17+K18+K19+K20+K21+K22+K23","v":{"v":216457,"d":"216457.00"}},"Rs."]
[null,null,"अधिकतम कटोती की राशि 1.50 लाख रूपये तक",{"$nulls":9},{"$f":"IF(K24<=150000,K24,150000)","v":{"v":150000,"d":"150000.00"}}]
[null,null,"धारा 80CCD(2) नियोक्ता द्वारा वेतन अंशदान की राशि ( अधिकतम वेतन का 10% ) पृथक से छूट ",{"$nulls":8},"Rs.",{"$f":"'GA55'!L32","v":{"v":84189,"d":"84189.00"}}]
[null,null,"धारा 80CCD(1B) नियोक्ता द्वारा नवीन पेंशन योजना में अतिरिक्त अंशदान की राशि ( अधिकतम 50000 ) पृथक से छूट ",{"$nulls":8},"Rs."]
[null,null,"योग 8 (अ + ब + स )",{"$nulls":8},"Rs.",{"$f":"M25+M26+M27","v":{"v":234189,"d":"234189.00"}}]
[null,"अन्य कटौतियां (VI A)-US80D,US80DD,US80DDB,US80E,US80G,US80GG,80U,80TTA etc."]
[null,9,1,"धारा 80D - चिकित्सा बीमा प्रीमियम ( सामान्य 25000, वरिष्ठ नागरिक 50000 )"," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 ","Rs.",{"v":0,"d":"0.00"}]
[null,null,2,"धारा 80DD -  विशेष योग्यजन आश्रितों के चिकित्सा उपचार ( अधिकतम  75000), 80%  विशेष योग्यजन 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000","Rs.",{"v":0,"d":"0.00"}]
[null,null,3,"धारा 80DDB -विशिष्ठ रोगों के चिकित्सा उपचार हेतु कटौती ( सामान्य 40000, वरिष्ठ नागरिक 100000 रुपये ) "," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000","Rs.",{"v":0,"d":"0.00"}]
[null,null,4,"धारा 80E -  उच्च शिक्षा हेतु ऋण पर ब्याज "," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt","Rs.",{"v":0,"d":"0.00"}]
[null,null,5,"धारा 80G -  धर्मार्थ संस्थाओं को दिए गए दान ( क श्रेणी 100% एंव ख श्रेणी 50 % )",{"$nulls":7},"Rs.",{"v":0,"d":"0.00"}]
[null,null,6,"धारा 80U -  स्थाई शारीरिक विशेष योग्यजन ( अधिकतम 75000, 80 % विशेष योग्यजन 125000 रूपये की छूट)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)","Rs.",{"v":0,"d":"0.00"}]
[null,null,7,"धारा 80GGA -  अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास हेतु दिया गया दान"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku","Rs.",{"v":0,"d":"0.00"}]
[null,null,8,"धारा 80 TTA -  बचत खाते के ब्याज पर छूट ( अधिकतम 10000 रूपये )"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku","Rs.",{"v":0,"d":"0.00"}]
[null,"कुल योग ( 1 से 8 तक )",{"$nulls":9},"Rs.",{"$f":"M30+M31+M32+M33+M34+M35+M36+M37","v":{"v":0,"d":"0.00"}}]
[null,10,"कुल कटौती",{"$nulls":8},"Rs.",{"$f":"M28+M38","v":{"v":234189,"d":"234189.00"}}]
[null,11,"कर योग्य आय",{"$nulls":8},"Rs.",{"$f":"M14-M39","v":{"v":648662,"d":"648662.00"}}]
[null,12,"कुल आय की राशि का 10 के गुणांक में गणना",{"$nulls":8},"Rs.",{"$f":"ROUND(M40,-1)","v":{"v":648660,"d":"648660.00"}}]
[null,13,"सामान्य आयकर स्लैब",{"$nulls":5},"आयकर योग्य राशि"]
[null,null,"0    - 2,50,000 ","0-250000","0-250000","0-250000","0-250000",{"v":0,"d":"0%"},{"$f":"IF($M$41>250000,250000,$M$41)","v":250000},null,null,"Rs.",{"$f":"I43*H43","v":{"v":0,"d":"0.00"}}]
[null,null,"2,50,001       -     5,00,000","250001-500000","250001-500000","250001-500000","250001-500000",{"v":0.05,"d":"5%"},{"$f":"IF($M$41>500000,250000,$M$41-I43)","v":250000},null,null,"Rs.",{"$f":"I44*H44","v":{"v":12500,"d":"12500.00"}}]
[null,null,"5,00,001     -      10,00,000","500001-750000","500001-750000","500001-750000","500001-750000",{"v":0.2,"d":"20%"},{"$f":"IF($M$41>1000000,500000,$M$41-I43-I44)","v":148660},null,null,"Rs.",{"$f":"I45*H45","v":{"v":29732,"d":"29732.00"}}]
[null,null,"10,00,001  -        12,50,000","1000001-1250000","1000001-1250000","1000001-1250000","1000001-1250000",{"v":0.3,"d":"30%"},{"$f":"IF($M$41>1250000,250000,$M$41-I45-I44-I43)","v":0},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"12,50,001    -      15,00,000","1250001-1500000","1250001-1500000","1250001-1500000","1250001-1500000",{"v":0.3,"d":"30%"},{"$f":"IF($M$41>1500000,250000,$M$41-I46-I45-I44-I43)","v":0},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null," Above 15,00,000","1250001-1500000","1250001-1500000","1250001-1500000","1250001-1500000",{"v":0.3,"d":"30%"},{"$f":"IF($M$41<1500000,0,$M$41-I47-I46-I45-I43-I44)","v":0},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,14,"योग आयकर",{"$nulls":5},{"$f":"I43+I44+I45+I46+I47+I48","v":{"v":648660,"d":"648660.00"}},null,null,"Rs.",{"$f":"M43+M44+M45+M46+M47+M48","v":{"v":42232,"d":"42232.00"}}]
[null,15,"धारा 87 (A) - ( 2.50 लाख से 5.00 लाख तक की कर योग्य आय पर अधिकतम छूट 12500 रूपये",{"$nulls":8},"Rs.",{"$f":"IF(M41<=500000,M44,0)","v":{"v":0,"d":"0.00"}}]
[null,"छूट के पश्चात् कुल आयकर",{"$nulls":9},"Rs.",{"$f":"M49-M50","v":{"v":42232,"d":"42232.00"}}]
[null,"शिक्षा उपकर 2% एंव उच्च शिक्षा के लिए अधिभार 2%  TOTAL 4%",{"$nulls":9},"Rs.",{"$f":"ROUND(M51*4%,0)","v":{"v":1689,"d":"1689.00"}}]
[null,"कुल आयकर",{"$nulls":9},"Rs.",{"$f":"M51+M52","v":{"v":43921,"d":"43921.00"}}]
[null,"राहत धारा 89 के तहत छूट ",{"$nulls":9},"Rs.",{"v":0,"d":"0.00"}]
[null,"कुल शेष आयकर",{"$nulls":9},"Rs.",{"$f":"M53-M54","v":{"v":43921,"d":"43921.00"}}]
[null,"विभिन्न स्रोतों से हुई मासिक आयकर कटौती"]
[null,null,{"$f":"'GA55'!C13","v":"2021-03-01"},null,null,{"$f":"'GA55'!U13","v":{"v":0,"d":"0.00"}},{"$f":"'GA55'!C19","v":"2021-09-01"},null,null,{"$f":"'GA55'!U19","v":{"v":0,"d":"0.00"}},null,"Rs.","अन्य एरियर से कटौती"]
[null,null,{"$f":"'GA55'!C14","v":"2021-04-01"},null,null,{"$f":"'GA55'!U14","v":{"v":0,"d":"0.00"}},{"$f":"'GA55'!C20","v":"2021-10-01"},null,null,{"$f":"'GA55'!U20","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null,{"$f":"'GA55'!C15","v":"2021-05-01"},null,null,{"$f":"'GA55'!U15","v":{"v":0,"d":"0.00"}},{"$f":"'GA55'!C21","v":"2021-11-01"},null,null,{"$f":"'GA55'!U21","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null,{"$f":"'GA55'!C16","v":"2021-06-01"},null,null,{"$f":"'GA55'!U16","v":{"v":0,"d":"0.00"}},{"$f":"'GA55'!C22","v":"2021-12-01"},null,null,{"$f":"'GA55'!U22","v":{"v":0,"d":"0.00"}},null,"Rs.",{"$f":"SUM('GA55'!U25:U31)","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"'GA55'!C17","v":"2021-07-01"},null,null,{"$f":"'GA55'!U17","v":{"v":0,"d":"0.00"}},{"$f":"'GA55'!C23","v":"2022-01-01"},null,null,{"$f":"'GA55'!U23","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null,{"$f":"'GA55'!C18","v":"2021-08-01"},null,null,{"$f":"'GA55'!U18","v":{"v":0,"d":"0.00"}},{"$f":"'GA55'!C24","v":"2022-02-01"},null,null,{"$f":"'GA55'!U24","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null," कुल  कटौती का योग",{"$nulls":8},"Rs.",{"$f":"F57+F58+F59+F60+F61+F62+J57+J58+J59+J60+J61+J62+M60","v":{"v":0,"d":"0.00"}}]
[null,null,"Income tax Refundable",{"$nulls":8},"Rs.",{"$f":"M63-M55","v":{"v":-43921,"d":"-43921.00"}}]
[]
[]
[{"$nulls":10},"हस्ताक्षर कर्मचारी/ अधिकारी"]

{"sheet":"NEW TAX REGIME","index":5,"n_rows":68,"n_cols":13,"rows_kept":68,"merged":[[0,1,0,12],[1,1,1,9],[1,10,1,12],[2,4,2,6],[2,8,2,9],[2,11,2,12],[3,3,3,4],[3,5,3,7],[3,8,3,9],[3,10,3,12],[4,3,4,10],[5,3,5,10],[6,3,6,10],[7,1,8,1],[7,3,7,9],[7,12,8,12],[8,3,8,9],[9,3,9,10],[10,1,12,1],[10,7,10,8],[10,12,12,12],[11,3,12,4],[11,5,11,6],[11,7,11,8],[12,5,12,6],[12,7,12,8],[13,3,13,10],[14,1,27,1],[14,3,14,10],[15,3,15,4],[15,7,15,9],[15,12,23,12],[16,3,16,4],[16,7,16,9],[17,3,17,4],[17,7,17,9],[18,3,18,4],[18,7,18,9],[19,3,19,4],[19,7,19,9],[20,3,20,4],[20,7,20,9],[21,3,21,4],[21,7,21,9],[22,3,22,4],[22,7,22,9],[23,3,23,4],[23,6,23,9],[24,2,24,11],[25,2,25,10],[26,2,26,10],[27,2,27,10],[28,1,28,12],[29,1,36,1],[29,3,29,10],[30,3,30,10],[31,3,31,10],[32,3,32,10],[33,3,33,10],[34,3,34,10],[35,3,35,10],[36,3,36,10],[37,1,37,10],[38,2,38,10],[39,2,39,10],[40,2,40,10],[41,2,41,7],[41,8,41,10],[42,1,48,1],[42,2,42,6],[42,8,42,10],[43,2,43,6],[43,8,43,10],[44,2,44,6],[44,8,44,10],[45,2,45,6],[45,8,45,10],[46,2,46,6],[46,8,46,10],[47,2,47,6],[47,8,47,10],[48,2,48,6],[48,8,48,10],[49,2,49,7],[49,8,49,10],[50,2,50,10],[51,1,51,10],[52,1,52,10],[53,1,53,10],[54,1,54,10],[55,1,55,10],[56,1,56,12],[57,2,57,4],[57,6,57,8],[57,9,57,10],[57,12,59,12],[58,2,58,4],[58,6,58,8],[58,9,58,10],[59,2,59,4],[59,6,59,8],[59,9,59,10],[60,2,60,4],[60,6,60,8],[60,9,60,10],[61,2,61,4],[61,6,61,8],[61,9,61,10],[61,12,62,12],[62,2,62,4],[62,6,62,8],[62,9,62,10],[63,2,63,10],[64,2,64,10],[65,2,65,10],[67,10,67,12]]}
[null,{"$f":"'GA55'!B7","v":"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR"}]
[null,"आयकर गणना प्रपत्र 2021-22 ( कर निर्धारण वर्ष 2022-23)",{"$nulls":8},"NEW TAX REGIME"]
[null,1,null,"नाम कर्मचारी",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,"पद",{"$f":"'GA55'!J9","v":"lecturer"},null,"PAN NO",{"$f":"'GA55'!O9","v":"QYPP0000J"}]
[{"$nulls":3},"Bank Ac.No.--",null,{"$f":"'GA55'!W10","v":61000000000},null,null,"Name Of Bank :",null,{"$f":"'GA55'!M10","v":"STATE BANK OF INDIA RIYAN BARI"}]
[null,2,null,"कुल वेतन (कर योग्य सुविधाओ सहित NPS सहित )",{"$nulls":7},"Rs.",{"$f":"'GA55'!AU28","v":{"v":990490,"d":"990490.00"}}]
[null,3,null,"ग्रह किराया धारा 10(13-I) के अंतर्गतएंव धारा 10(14) के अंतर्गतअन्यभत्ते जो करमुक्त हो",{"$nulls":7},"Rs.",{"v":0,"d":"0.00"}]
[null,4,null,"शेष (2-3) -WITH EXEMPT STANDARD DEDUCTION MAX. 50000",{"$nulls":7},"Rs.",{"$f":"M5-M6-50000","v":{"v":940490,"d":"940490.00"}}]
[null,5,null,"(i) मनोरंजन भत्ता धारा 16(i) के अंतर्गत ( अधिकतम सीमा रू 5000 )",{"$nulls":6},{"v":0,"d":"0.00"},"Rs."]
[{"$nulls":3},"(ii)  व्यवसाय कर धारा 16(ii) के अंतर्गत ( अधिकतम सीमा रू 5000 )",{"$nulls":6},{"v":0,"d":"0.00"},"Rs."]
[null,6,null,"शेष (4-5) ",{"$nulls":7},"Rs.",{"$f":"M7-K8-K9","v":{"v":940490,"d":"940490.00"}}]
[null,7,null,"(अ) ग्रह सम्पति से आय (1) स्वंय के उपयोग में - शून्य",{"$nulls":5},"(2) प्राप्त किराया रू",null,"Rs."]
[{"$nulls":3},"(ब) घटाए",null,"किराये का 30%",null,"ग्रह ऋण पर ब्याज",null,"गृहकर","योग 7 (ब)","Rs."]
[{"$nulls":5},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"$f":"F13+H13+I13+J13+G13","v":{"v":0,"d":"0.00"}},"Rs."]
[{"$nulls":3},"कुल सकल आय",{"$nulls":7},"Rs.",{"$f":"M10-K13","v":{"v":940490,"d":"940490.00"}}]
[null,8,"(A)","Chapter VI A Deductions( max 150000) ",{"$nulls":7},"Rs."]
[null,null,"(i)","GPF",null,{"$f":"'GA55'!M32","v":{"v":0,"d":"0.00"}},"(x)","FIXED DEPOSIT 5 YEAR",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(ii)","SI",null,{"v":0,"d":"0.00"},"(xi)","TUSION FEES",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(iii)","LIC ( from salary)",null,{"v":0,"d":"0.00"},"(xii)","NPS CONTRIBUTION ",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(iv)","LIC ( by Self)",null,{"v":0,"d":"0.00"},"(xiii)","PENSION PLAN (US 80CCC)",null,null,{"v":540,"d":"540.00"},"Rs."]
[null,null,"(v)","PPF",null,{"v":0,"d":"0.00"},"(xiv)","DEFFERED ANNUTY",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(vi)","PLI",null,{"v":0,"d":"0.00"},"(xv)","ULIP",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(vii)","NSC",null,{"v":0,"d":"0.00"},"(xvi)","GIS",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(viii)","HBA Premium",null,{"v":0,"d":"0.00"},"(xvii)","सुकन्या समृद्धि योजना",null,null,{"v":0,"d":"0.00"},"Rs."]
[null,null,"(ix)","NSS",null,{"v":0,"d":"0.00"},"Total( I to xvii)",{"$nulls":3},{"v":0,"d":"0.00"},"Rs."]
[null,null,"अधिकतम कटोती की राशि 1.50 लाख रूपये तक",{"$nulls":9},{"$f":"IF(K24<=150000,K24,150000)","v":{"v":0,"d":"0.00"}}]
[null,null,"धारा 80CCD(2) नियोक्ता द्वारा वेतन अंशदान की राशि ( अधिकतम वेतन का 10% ) पृथक से छूट ",{"$nulls":8},"Rs.",{"$f":"K18","v":{"v":0,"d":"0.00"}}]
[null,null,"धारा 80CCD(1B) नियोक्ता द्वारा नवीन पेंशन योजना में अतिरिक्त अंशदान की राशि ( अधिकतम 50000 ) पृथक से छूट ",{"$nulls":8},"Rs.",{"$f":"IF(K26<=150000,K26,150000)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 8 (अ + ब + स )",{"$nulls":8},"Rs.",{"$f":"M25+M26+M27","v":{"v":0,"d":"0.00"}}]
[null,"अन्य कटौतियां (VI A)-US80D,US80DD,US80DDB,US80E,US80G,US80GG,80U,80TTA etc."]
[null,9,1,"धारा 80D - चिकित्सा बीमा प्रीमियम ( सामान्य 25000, वरिष्ठ नागरिक 50000 )"," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 "," /kkjk 80D -  fpfdRlk chek izhfe;e ¼lkekU; 25000]ofj\"B ukxfjd 50000 ","Rs.",{"v":0,"d":"0.00"}]
[null,null,2,"धारा 80DD -  विशेष योग्यजन आश्रितों के चिकित्सा उपचार ( अधिकतम  75000), 80%  विशेष योग्यजन 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000"," /kkjk 80DD -  fo'ks\"k ;ksX;tu vkfJrksa ds fpfdRlk mipkj  ¼vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000","Rs.",{"v":0,"d":"0.00"}]
[null,null,3,"धारा 80DDB -विशिष्ठ रोगों के चिकित्सा उपचार हेतु कटौती ( सामान्य 40000, वरिष्ठ नागरिक 100000 रुपये ) "," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000"," /kkjk 80DDB -  fof'k\"V jkxks  ds fpfdRlk mipkj gsrq dVkSrh ¼lkekU; 40000]ofj\"B ukxfjd 100000","Rs.",{"v":0,"d":"0.00"}]
[null,null,4,"धारा 80E -  उच्च शिक्षा हेतु ऋण पर ब्याज "," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt"," /kkjk 80E -  mPp f'k{kk gsrq _.k ij C;kt","Rs.",{"v":0,"d":"0.00"}]
[null,null,5,"धारा 80G -  धर्मार्थ संस्थाओं को दिए गए दान ( क श्रेणी 100% एंव ख श्रेणी 50 % )",{"$nulls":7},"Rs.",{"$f":"K34+I34","v":{"v":0,"d":"0.00"}}]
[null,null,6,"धारा 80U -  स्थाई शारीरिक विशेष योग्यजन ( अधिकतम 75000, 80 % विशेष योग्यजन 125000 रूपये की छूट)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)"," /kkjk 80U -  LFkkbZ 'kkjhfjd fo'ks\"k ;ksX;tu ¼ vf/kdre  75000]80% fo'ks\"k ;ksX;tu 125000)","Rs.",{"v":0,"d":"0.00"}]
[null,null,7,"धारा 80GGA -  अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास हेतु दिया गया दान"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku","Rs.",{"v":0,"d":"0.00"}]
[null,null,8,"धारा 80 TTA -  बचत खाते के ब्याज पर छूट ( अधिकतम 10000 रूपये )"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku"," /kkjk 80GGA -  vuqekfnr oSKkfud]lkekftd]xzkeh.k fodkl gsrq fn;k x;k nku","Rs.",{"v":0,"d":"0.00"}]
[null,"कुल योग ( 1 से 8 तक )",{"$nulls":9},"Rs.",{"$f":"M30+M31+M32+M33+M34+M35+M36+M37","v":{"v":0,"d":"0.00"}}]
[null,10,"कुल कटौती",{"$nulls":8},"Rs.",{"$f":"M28+M38","v":{"v":0,"d":"0.00"}}]
[null,11,"कर योग्य आय",{"$nulls":8},"Rs.",{"$f":"M14-M39","v":{"v":940490,"d":"940490.00"}}]
[null,12,"कुल आय की राशि का 10 के गुणांक में गणना",{"$nulls":8},"Rs.",{"$f":"ROUND(M40,-1)","v":{"v":940490,"d":"940490.00"}}]
[null,13,"सामान्य आयकर स्लैब",{"$nulls":5},"आयकर योग्य राशि"]
[null,null,"0    - 2,50,000 ","0-250000","0-250000","0-250000","0-250000",{"v":0,"d":"0%"},{"$f":"IF($M$41>250000,250000,$M$41)","v":250000},null,null,"Rs.",{"$f":"I43*H43","v":{"v":0,"d":"0.00"}}]
[null,null,"2,50,001       -     5,00,000","250001-500000","250001-500000","250001-500000","250001-500000",{"v":0.05,"d":"5%"},{"$f":"IF($M$41>500000,250000,$M$41-I43)","v":250000},null,null,"Rs.",{"$f":"ROUND(I44*H44,0)","v":{"v":12500,"d":"12500.00"}}]
[null,null,"5,00,001       -     7,50,000","250001-500000","250001-500000","250001-500000","250001-500000",{"v":0.1,"d":"10%"},{"$f":"IF($M$41>500000,250000,$M$41-I44)","v":250000},null,null,"Rs.",{"$f":"ROUND(I45*H45,0)","v":{"v":25000,"d":"25000.00"}}]
[null,null,"7,50,001     -      10,00,000","500001-750000","500001-750000","500001-750000","500001-750000",{"v":0.15,"d":"15%"},{"$f":"IF($M$41>1000000,500000,$M$41-I43-I44)","v":440490},null,null,"Rs.",{"$f":"ROUND(I46*H46,0)","v":{"v":66074,"d":"66074.00"}}]
[null,null,"10,00,001  -        12,50,000","1000001-1250000","1000001-1250000","1000001-1250000","1000001-1250000",{"v":0.2,"d":"20%"},{"$f":"IF($M$41>1250000,500000,$M$41-I44-I46-I43)","v":0},null,null,"Rs.",{"$f":"I47*H47","v":{"v":0,"d":"0.00"}}]
[null,null,"12,50,001  -        15,00,000","1000001-1250000","1000001-1250000","1000001-1250000","1000001-1250000",{"v":0.25,"d":"25%"},{"$f":"IF($M$41>1500000,250000,$M$41-I46-I47-I44-I43)","v":0},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null," Above 15,00,000","1250001-1500000","1250001-1500000","1250001-1500000","1250001-1500000",{"v":0.3,"d":"30%"},{"$f":"IF($M$41<1500000,,$M$41-I47-I48-I46-I44-I43)","v":0},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,14,"योग आयकर",{"$nulls":5},{"$f":"I44+I45+I46+I47+I48+I49","v":{"v":940490,"d":"940490.00"}},null,null,"Rs.",{"$f":"SUM(M43:M49)","v":{"v":103574,"d":"103574.00"}}]
[null,15,"धारा 87 (A) - ( 2.50 लाख से 5.00 लाख तक की कर योग्य आय पर अधिकतम छूट 12500 रूपये",{"$nulls":8},"Rs.",{"$f":"IF(M41<=500000,M44,0)","v":{"v":0,"d":"0.00"}}]
[null,"छूट के पश्चात् कुल आयकर",{"$nulls":9},"Rs.",{"$f":"M50-M51","v":{"v":103574,"d":"103574.00"}}]
[null,"शिक्षा उपकर 2% एंव उच्च शिक्षा के लिए अधिभार 2%  TOTAL 4%",{"$nulls":9},"Rs.",{"$f":"ROUND(M52*4%,0)","v":{"v":4143,"d":"4143.00"}}]
[null,"कुल आयकर",{"$nulls":9},"Rs.",{"$f":"ROUND(M52+M53,0)","v":{"v":107717,"d":"107717.00"}}]
[null,"राहत धारा 89 के तहत छूट ",{"$nulls":9},"Rs.",{"v":0,"d":"0.00"}]
[null,"कुल शेष आयकर",{"$nulls":9},"Rs.",{"$f":"M54-M55","v":{"v":107717,"d":"107717.00"}}]
[null,"विभिन्न स्रोतों से हुई मासिक आयकर कटौती"]
[null,null,{"$f":"'OLD TAX REGIME'!C57:E57","v":"2021-03-01"},null,null,{"$f":"'GA55'!U13","v":{"v":0,"d":"0.00"}},{"$f":"'OLD TAX REGIME'!G57:I57","v":"2021-09-01"},null,null,{"$f":"'GA55'!U19","v":{"v":0,"d":"0.00"}},null,"Rs.","अन्य एरियर से कटौती"]
[null,null,{"$f":"'OLD TAX REGIME'!C58:E58","v":"2021-04-01"},null,null,{"$f":"'GA55'!U14","v":{"v":0,"d":"0.00"}},{"$f":"'OLD TAX REGIME'!G58:I58","v":"2021-10-01"},null,null,{"$f":"'GA55'!U20","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null,{"$f":"'OLD TAX REGIME'!C59:E59","v":"2021-05-01"},null,null,{"$f":"'GA55'!U15","v":{"v":0,"d":"0.00"}},{"$f":"'OLD TAX REGIME'!G59:I59","v":"2021-11-01"},null,null,{"$f":"'GA55'!U21","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null,{"$f":"'OLD TAX REGIME'!C60:E60","v":"2021-06-01"},null,null,{"$f":"'GA55'!U16","v":{"v":0,"d":"0.00"}},{"$f":"'OLD TAX REGIME'!G60:I60","v":"2021-12-01"},null,null,{"$f":"'GA55'!U22","v":{"v":0,"d":"0.00"}},null,"Rs.",{"$f":"SUM('GA55'!U25:U31)","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"'OLD TAX REGIME'!C61:E61","v":"2021-07-01"},null,null,{"$f":"'GA55'!U17","v":{"v":0,"d":"0.00"}},{"$f":"'OLD TAX REGIME'!G61:I61","v":"2022-01-01"},null,null,{"$f":"'GA55'!U23","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null,{"$f":"'OLD TAX REGIME'!C62:E62","v":"2021-08-01"},null,null,{"$f":"'GA55'!U18","v":{"v":0,"d":"0.00"}},{"$f":"'OLD TAX REGIME'!G62:I62","v":"2022-02-01"},null,null,{"$f":"'GA55'!U24","v":{"v":0,"d":"0.00"}},null,"Rs."]
[null,null," कुल  कटौती का योग",{"$nulls":8},"Rs.",{"$f":"F58+F59+F60+F61+F62+F63+J58+J59+J60+J61+J62+J63+M61","v":{"v":0,"d":"0.00"}}]
[null,null,"Income tax Refundable",{"$nulls":8},"Rs.",{"$f":"M56-M64","v":{"v":107717,"d":"107717.00"}}]
[]
[]
[{"$nulls":10},"हस्ताक्षर कर्मचारी/ अधिकारी"]

{"sheet":"PAY SLIP","index":6,"n_rows":46,"n_cols":17,"rows_kept":46,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,2],[2,3,2,9],[3,1,3,2],[3,3,3,5],[3,6,3,7],[3,8,3,9],[4,4,4,6],[5,1,5,3],[5,6,5,7],[7,2,7,5],[7,6,7,7],[7,8,7,9],[9,1,9,3],[9,6,9,8],[11,1,11,2],[11,3,11,5],[11,7,11,9],[13,1,13,3],[13,6,13,7],[13,8,13,9],[15,1,15,2],[15,3,15,5],[15,7,15,9],[17,1,17,3],[17,6,17,8],[19,1,19,2],[19,3,19,9],[21,1,22,4],[21,6,22,9],[22,5,31,5],[23,1,23,2],[23,3,23,4],[23,6,23,7],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,6,24,7],[24,8,24,9],[25,1,25,2],[25,3,25,4],[25,6,25,7],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,6,26,7],[26,8,26,9],[27,1,27,2],[27,3,27,4],[27,6,27,7],[27,8,27,9],[28,1,28,2],[28,3,28,4],[28,6,28,7],[28,8,28,9],[29,1,29,2],[29,3,29,4],[29,6,29,7],[29,8,29,9],[30,1,30,2],[30,3,30,4],[30,6,30,7],[30,8,30,9],[31,1,31,2],[31,3,31,4],[31,6,31,7],[31,8,31,9],[32,1,33,2],[32,3,33,4],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[34,1,34,4],[34,6,34,9],[35,3,35,4],[36,3,36,4],[36,5,36,6],[37,1,37,2],[37,3,37,9],[43,1,43,5],[43,6,43,9],[45,1,45,2],[45,3,45,4]]}
[null,"वेतन पर्ची"]
[null,"Pay Slip"]
[null,"DDO   OFFICE   : ",null,{"$f":"'GA55'!B7","v":"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR"}]
[null,"TV NO.& DATE :",null,{"$f":"VLOOKUP(E5,'GA55'!C13:Y31,23,0)","v":0},null,null,"BILL NO. & DATE :",null,{"$f":"VLOOKUP(E5,'GA55'!C13:Y24,22,0)","v":0}]
[{"$nulls":3},"Month :","2021-08-01",{"$nulls":11},{"$f":"'GA55'!C13","v":"2021-03-01"}]
[null,"कर्मचारी का नाम",{"$nulls":4},"पदनाम",{"$nulls":9},{"$f":"'GA55'!C14","v":"2021-04-01"}]
[{"$nulls":16},{"$f":"'GA55'!C15","v":"2021-05-01"}]
[null,"NAME",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},{"$nulls":3},"Designation :",null,{"$f":"'GA55'!J9","v":"lecturer"},{"$nulls":7},{"$f":"'GA55'!C16","v":"2021-06-01"}]
[{"$nulls":16},{"$f":"'GA55'!C17","v":"2021-07-01"}]
[null,"कर्मचारी पहचान संख्या",{"$nulls":4},"बैंक खाता संख्या",{"$nulls":9},{"$f":"'GA55'!C18","v":"2021-08-01"}]
[{"$nulls":16},{"$f":"'GA55'!C19","v":"2021-09-01"}]
[null,"Emp. Id",null,{"$f":"'GA55'!W11","v":"RJNA0000000000"},null,null,"A/C. No.",{"$f":"'GA55'!W10","v":61000000000},{"$nulls":8},{"$f":"'GA55'!C20","v":"2021-10-01"}]
[{"$nulls":16},{"$f":"'GA55'!C21","v":"2021-11-01"}]
[null,"जीपीएफ",{"$nulls":4},"एसआई नम्बर",{"$nulls":9},{"$f":"'GA55'!C22","v":"2021-12-01"}]
[{"$nulls":16},{"$f":"'GA55'!C23","v":"2022-01-01"}]
[null,"GPF/CPF No.",null,{"$f":"'GA55'!H10","v":111111111111},null,null,"SI No.",{"$f":"'GA55'!D10","v":0},{"$nulls":8},{"$f":"'GA55'!C24","v":"2022-02-01"}]
[]
[null,"बैंक शाखा"]
[]
[null,"Bank/ Branch",null,{"$f":"'GA55'!M10","v":"STATE BANK OF INDIA RIYAN BARI"}]
[]
[null,"INCOME",{"$nulls":4},"DEDUCTION"]
[]
[null,"Basic",null,{"$f":"VLOOKUP(E5,ga,2,0)","v":{"v":53900,"d":"53900.00"}},null,null,"ECPenF",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,10,0)","v":{"v":6899,"d":"6899.00"}}]
[null,"D.A.",null,{"$f":"VLOOKUP($E$5,'GA55'!C13:Y24,3,0)","v":{"v":15092,"d":"15092.00"}},null,null,"GPF",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,11,0)","v":{"v":0,"d":"0.00"}}]
[null,"H.R.A.",null,{"$f":"VLOOKUP($E$5,'GA55'!C13:Y24,4,0)","v":{"v":4851,"d":"4851.00"}},null,null,"GPF LOAN",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,12,0)","v":{"v":0,"d":"0.00"}}]
[null,"Washing Allowance",null,{"v":0,"d":"0.00"},null,null,"SI",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,14,0)","v":{"v":7000,"d":"7000.00"}}]
[null,"Handicap allowance",null,{"v":0,"d":"0.00"},null,null,"SI LOAN",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,15,0)","v":{"v":0,"d":"0.00"}}]
[null,"BONUS",null,{"v":0,"d":"0.00"},null,null,"RPMF",null,{"v":0,"d":"0.00"}]
[null,"Other",null,{"v":0,"d":"0.00"},null,null,"LIC",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,16,0)","v":{"v":1070,"d":"1070.00"}}]
[null,"Other",null,{"v":0,"d":"0.00"},null,null,"IT. TAX",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,19,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},"GIS",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,17,0)","v":{"v":0,"d":"0.00"}}]
[null,"TOTAL PAY",null,{"$f":"VLOOKUP(E5,'GA55'!C13:W24,9,0)","v":{"v":73843,"d":"73843.00"}},null,null,"COVID 19",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$W$24,18,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},"TOTAL DED.:",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,20,0)","v":{"v":15299,"d":"15299.00"}}]
[]
[{"$nulls":3},"नियत वेतन"]
[{"$nulls":3},"NET PAY",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,21,0)","v":{"v":58544,"d":"58544.00"}},null,"Rs."]
[null,"RUPEES IN WORDS ",null,{"$f":"PROPER(SpellNumber(F37))","v":"Fifty-Eight Thousand Five Hundred Forty-Four"}]
[]
[]
[]
[]
[]
[null,"Signature of Employee",{"$nulls":4},"Signature of DDO"]
[]
[null,"Print Date:",null,{"$f":"NOW()","v":"2021-12-05T11:51:20.910"}]