{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["info","GA55","7pay matrix chart","TAX CALCULATION","OLD TAX REGIME","NEW TAX REGIME","PAY SLIP"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":24,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"info","index":0,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,33,6],[32,7,33,9],[32,10,33,15],[4,1,8,1],[30,9,31,12],[30,3,31,8],[26,3,26,15],[27,3,29,5],[27,6,29,8],[27,9,29,12],[27,13,29,15],[22,3,22,15],[23,3,23,15],[24,3,24,15],[25,6,25,7],[25,8,25,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],[13,2,13,15],[14,2,14,15],[15,1,16,1],[15,2,15,15],[16,2,16,15],[30,13,31,15],[1,1,1,15],[6,2,6,15],[7,2,7,15],[4,2,4,15],[5,2,5,15],[2,1,2,15],[3,1,3,15],[8,2,8,15],[10,2,10,15],[12,2,12,15],[9,1,10,1],[9,2,9,15],[11,1,12,1],[11,2,11,15],[13,1,14,1]]}
[]
[null,"INCOMETAX 2022-23 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,"आपकी सुरक्षा ही मेरी उर्जा है अतः कोविड नियमो का पालन करे",null,null,null,"आप मेरा youtube चैनल भी देख और SUBSCRIBE और LIKE कर सकते है",null,null,null,null,null,"https://youtu.be/3yHQVnwH1W0"]
[]
[null,null,null,"दोस्तों यह PROGRAMME आपको कैसा लगा मेरी MAIL ID पर जरुर बताये "]
[null,null,null,"आपका विजय कुमार प्रजापत अध्यापक "]
[null,null,null,"राजकीय उच्च माध्यमिक विद्यालय आलनियावास तह. रियां बड़ी जिला- नागौर "]
[null,null,null,null,null,null,9828120697,null,"कृपया इस नम्बर पर केवल MASSAGE करे CALL नहीं करे"]
[null,null,null,"मेरे प्रेरणास्रोत --- अश्विनीकुमारजी,किशन जी सेन,विष्णुजी शर्मा,मोहम्मद शरीफ जी,परमानन्द जी,हीरालाल जी जाट और आप"]
[null,null,null,"कृपया मेरे अन्य सभी 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",null,null,null,"http://www.shalasugam.com/vijay-kumar-excel-expert/"]
[]
[]
[null,null,null,"नोट-- यह programe आपकी सुविधा हेतु बनाया गया है एंव GA55 से TALLY करके बनाये औरआयकर विभाग के नियम ही अंतिम होंगे|",null,null,null,null,null,"https://rajteachers.net/vijay-kumar-prajapat",null,null,null,"यह software PC,LAPTOP एंव MOBILE पर भी USE कर सकते है मोबाइल में WPS जैसे APP हो एंव EDIT OPTION में प्रत्येक cell में entry करे"]
[]
[null,"KEEP YOUR FACE ALWAYS IN SUNSHINE",null,null,null,null,null,"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,"cut":false,"hidden":false,"merged":[[0,50,5,50],[21,35,21,36],[3,16,3,18],[3,19,3,21],[16,35,16,40],[17,35,17,36],[18,35,18,36],[19,35,19,36],[20,35,20,36],[6,1,6,24],[8,22,8,24],[7,22,7,24],[8,1,8,2],[2,23,3,24],[1,19,1,21],[4,1,4,10],[0,0,4,0],[2,19,2,21],[0,1,0,18],[0,19,0,21],[7,18,7,21],[4,12,4,21],[5,12,5,21],[7,1,7,17],[3,1,3,14],[2,1,2,7],[2,10,2,18],[2,8,2,9],[1,1,1,18],[5,1,5,4],[5,5,5,11],[37,2,37,4],[10,15,10,18],[10,19,10,21],[10,22,10,24],[10,3,10,6],[10,7,10,8],[10,9,10,11],[36,2,36,6],[36,19,36,23],[10,1,10,2],[10,12,10,14],[0,49,4,49],[9,1,9,2],[9,3,9,4],[9,22,9,24],[9,5,9,7],[9,8,9,10],[9,12,9,17],[9,19,9,21],[8,3,8,6],[8,8,8,10],[8,19,8,21],[1,23,1,24],[4,23,5,24],[15,62,16,64],[8,14,8,18],[35,2,35,6],[35,19,35,23],[36,9,36,15]]}
[null,"आप आयकर गणना प्रपत्र पुराना लेना चाहते है तो DROPDOWN MENU में OLD अथवा नए के लिए new का चयन करे |",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OLD","TAX",{"$f":"IF(W1=\"OLD\",'OLD TAX REGIME'!M56,'NEW TAX REGIME'!M57)","v":35219},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"सबसे पहले मार्च basic डार्क cell में लिखे फिर SIP,SIL,GPF,LIC,  GIL,IT की कटोती MANUAL मार्च22 से करे  और PRINT करे"]
[null,"क्या आप 01.01.2004 के बाद नियुक्त है तो DROPDOWN मेनू में YES अथवा NO का चयन करे|",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES","HRA",null,null,null,null,{"$f":"IF(W2=\"yes\",AB13,IF(W2=\"no\",AC16))","v":5541},null,null,null,null,null,null,null,null,null,1,{"$f":"W9","v":42300},31,{"$f":"AN2/AO2*15","v":20467.741935483871},{"$f":"ROUND(AP2,0)","v":20468},{"$f":"ROUND(AQ2*17/100,0)","v":3480}]
[null,"कर्मचारी का राज्य सेवा में प्रकार",null,null,null,null,null,null,"REGULAR",null,"क्या आपको बोनस मिला है तो YES अथवा NO का चयन करे",null,null,null,null,null,null,null,null,null,null,null,"YES",null,null,null,null,null,null,null,null,0.08,null,null,null,null,null,null,2,{"$f":"D14","v":42300},29,{"$f":"AN3/AO3*15","v":21879.310344827583},{"$f":"ROUND(AP3,0)","v":21879},{"$f":"ROUND(AQ3*17/100,0)","v":3719}]
[null,"क्या आपको समर्पित अवकाश मिला है तो YES अथवा NO का चयन करे",null,null,null,null,null,null,null,null,null,null,null,null,null,"YES","किस माह में उठाया",null,null,null,null,null,4,null,null,null,null,null,"YES",null,",uih,l",0.16,null,null,null,null,null,null,3,{"$f":"D15","v":42300},31,20467.741935483871,20468,3480,null,null,null,"OLD"]
[null,"क्या आपको विशेषयोग्यजन कर्मचारी भत्ता मिलता है|",null,null,null,null,null,null,null,null,null,"NO","क्या आपको HRA की छूट देय है  ",null,null,null,null,null,null,null,null,null,"YES",0.09,null,null,null,null,null,null,"thih,Q",null,null,null,null,null,null,null,4,{"$f":"D16","v":42300},30,21150,21150,3596,null,null,null,"NEW"]
[null,"आपके DDO का नाम/PRICIPAL",null,null,null,"श्री करमा राम",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGULAR","YES",null,null,null,null,null,null,null,null,5,{"$f":"D17","v":43600},31,21096.774193548386,21097,3586,null,null,null,null,null,null,null,null,null,null,null,null,null,"OLD TAX REGIME"]
[null,"वेतन एंव कर निर्धारण वर्ष 2022-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"आयकर स्लैब का चयन :-",null,null,null,"OLD TAX REGIME",null,null,null,null,null,"PROBATION","NO","YES","surender",2,null,null,"GPF",null,null,6,43600,30,21800,21800,3706,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEW TAX REGIME"]
[null,"नाम कर्मचारी :",null,"VIJAY KUMAR PRAJAPAT",null,null,null,"पद :","LECTURER",null,null,"लेवल :","L-12","पेन न :","QYPP0000J",null,null,null,null,"Basic Pay (IN MARCH)",null,null,42300,null,null,null,null,null,null,{"$f":"IF(AC4>=\"YES\",(D13+E13)*10/100)","v":5541.3},"NO",null,null,null,null,"GPF04",null,null,7,43600,31,21096.774193548386,21097,{"$f":"ROUND(AQ9*31/100,0)","v":6540},null,null,null,null,null,null,null,null,null,"(    OLD TAX REGIME    )"]
[null,"राज्य बीमा  :",null,457858,null,"जीपीएफ/एनपीएस:",null,null,45,null,null,"बैंक ब्रांच","STATE BANK OF INDIA RIYAN BARI",null,null,null,null,null,null,"Bank A/c :",null,null,61000000000,null,null,null,{"$f":"ROUND(W9-(W9*0.03),2)","v":41031},{"$f":"ROUND(AA10,-2)","v":41000},null,null,null,{"$f":"VLOOKUP(L5,B13:E24,3,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,8,43600,31,21096.774193548386,21097,{"$f":"ROUND(AQ10*31/100,0)","v":6540},null,null,null,null,null,null,null,null,null,"(    NEW TAX REGIME        )"]
[null,"आधार नम्बर :",null,333333333333,null,null,null,"टेन नम्बर :",null,"JDHG00000H",null,null,"मोबाइल नम्बर :",null,null,9828120697,null,null,null,"EMPLOYEE ID :",null,null,"RJNA0000000000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"D20","v":43600},30,{"$f":"AN11/AO11*15","v":21800},{"$f":"ROUND(AP11,0)","v":21800},6758,null,null,null,null,null,null,null,null,null,null,null,null,{"$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",{"$f":"IF(W2=\"YES\",\"GPF4\",\"GPF\")","v":"GPF4"},{"$f":"IF(W2=\"YES\",\"GPF04 LOAN\",\"GPF LOAN\")","v":"GPF04 LOAN"},"RPMF/RGHS","SIP","SIL","LIC","GIS","OTHER DED.1","OTHER DED.2","Income tax","Total ded.","NET PAY","Bill No.","TV. No.",null,null,null,{"$f":"AA10/31*16","v":21177.290322580644},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"}},null,null,null,null,10,43600,31,21096.774193548386,21097,6540]
[null,1,"2022-03-01",{"$f":"BA13","v":42300},{"$f":"IF($I$3=\"REGULAR\",ROUND((D13*31/100),0),0)","v":13113},{"$f":"IF($I$3=\"REGULAR\",ROUND((D13*$X$5),0),0)","v":3807},{"$f":"IF($L$5=\"yes\",600,\"\")","v":""},null," "," ",{"$f":"SUM(D13:J13)","v":59220},2000,0,{"$f":"IF($W$2=\"no\",$AJ$26,$AJ$26 )","v":658},7000,0,100,null,null,null,0,{"$f":"SUM(L13:U13)","v":9758},{"$f":"K13-V13","v":49462},"111/1-4-20","45/4-4-2020",null,{"$f":"K13","v":59220},{"$f":"ROUND(((D13+E13)*10/100),0)","v":5541},{"$f":"(AA10/31)*5","v":6617.9032258064508},{"$f":"ROUND(AC13,0)","v":6618},"TEACHER",3,"B",null,{"$f":"IF(W2=\"YES\",\" \",AJ25)","v":" "},null,null,null,11,43600,30,21800,21800,6758,null,null,null,null,null,null,null,null,{"$f":"W9","v":42300}]
[null,2,"2022-04-01",{"$f":"BA14","v":42300},{"$f":"IF($I$3=\"REGULAR\",ROUND((D14*34/100),0),0)","v":14382},{"$f":"IF($I$3=\"REGULAR\",ROUND((D14*$X$5),0),0)","v":3807},{"$f":"IF($L$5=\"yes\",600,\"\")","v":""},null,null,null,{"$f":"SUM(D14:J14)","v":60489},{"$f":"L13","v":2000},{"$f":"M13","v":0},658,{"$f":"O13","v":7000},{"$f":"P13","v":0},{"$f":"Q13","v":100},0,null,null,{"$f":"U13","v":0},{"$f":"SUM(L14:U14)","v":9758},{"$f":"K14-V14","v":50731},null,null,null,{"$f":"K14","v":60489},{"$f":"ROUND(((D14+E14)*10/100),0)","v":5668},{"$f":"(AA10/31)*3","v":3970.7419354838707},{"$f":"ROUND(AC14,0)","v":3971},"SR.TEACHER",3,"B",null,{"$f":"IF($W$3=\"YES\",\" \",AJ26)","v":" "},null,null,null,12,43600,31,21096.774193548386,21097,6540,null,null,null,null,null,null,null,null,{"$f":"W9","v":42300}]
[null,3,"2022-05-01",{"$f":"BA15","v":42300},{"$f":"IF($I$3=\"REGULAR\",ROUND((D15*34/100),0),0)","v":14382},3807,"",null,null,null,60489,2000,0,658,{"$f":"O14","v":7000},0,100,null,null,null,0,{"$f":"SUM(L15:U15)","v":9758},{"$f":"K15-V15","v":50731},null,null,null,60489,5668,{"$f":"(AA10/31)*2","v":2647.1612903225805},2647,"LECTURER",5,"A",null,{"$f":"IF(W4=\"YES\",\" \",AJ27)","v":330},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA14","v":42300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D16","v":42300}]
[null,4,"2022-06-01",42300,14382,3807,null,null,null,null,60489,2000,0,658,{"$f":"O15","v":7000},0,100,null,null,null,0,9758,50731,null,null,null,60489,5668,null,"A","HEADMASTER",5,"A",null,{"$f":"IF(W5=\"YES\",\" \",AJ28)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA15","v":42300},null,null,null,null,null,null,null,null,null,"Rates prescribed by the Government from March, 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14","v":42300},{"$f":"BY16*34/100","v":14382},{"$f":"BY16*31/100","v":13113},{"$f":"BZ16-CA16","v":1269},{"$f":"CB16*10/100","v":126.9},{"$f":"CB16-CC16","v":1142.0999999999999}]
[null,5,"2022-07-01",43600,{"$f":"IF($I$3=\"REGULAR\",ROUND((D17*34/100),0),0)","v":14824},3924,"",null,null,null,62348,2000,0,658,{"$f":"O16","v":7000},0,{"$f":"Q16","v":100},null,null,null,0,9758,52590,null,null,null,62348,5842,null,"A","PRINCIPAL",5,"A",null,{"$f":"IF(W7=\"YES\",\" \",AJ29)","v":"L-1"},"RPMF RATES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I3=\"REGULAR\",ROUND(BA16+(BA16*0.03),-2),W9)","v":43600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14","v":42300},{"$f":"BY17*34/100","v":14382},{"$f":"BY17*31/100","v":13113},{"$f":"BZ17-CA17","v":1269},{"$f":"CB17*10/100","v":126.9},{"$f":"CB17-CC17","v":1142.0999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F18-F17","v":0}]
[null,6,"2022-08-01",43600,{"$f":"IF($I$3=\"REGULAR\",ROUND((D18*34/100),0),0)","v":14824},3924,"",null,null,null,62348,2000,0,658,{"$f":"O17","v":7000},0,100,null,null,null,{"$f":"U17","v":0},9758,52590,null,null,null,62348,5842,null,"B","PRABODHAK",3,"B",null,{"$f":"IF(W8=\"YES\",\" \",AJ31)","v":"L-3"},"PAY RANGE",null,"2017-10-01","2017-11-01","2019-04-01","2020-04-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA17","v":43600},null,null,null,null,null,null,null,null,null,"Sl. No.","Pay drawn in Pay Matrix","Rate of Subscription in Rs.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14","v":42300},14382,13113,1269,126.9,1142.0999999999999]
[null,7,"2022-09-01",43600,14824,3924,"",null,null,null,62348,2000,0,658,{"$f":"O18","v":7000},0,100,null,null,null,0,9758,52590,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":62348},5842,null,"B","LAB. ASSISTANT",3,"B",null,"L-4","UP TO   18000",null,205,210,242,265,242,265,135,265,null,null,null,null,null,null,null,{"$f":"BA18","v":43600},null,null,null,null,null,null,null,null,null,1,"Upto Rs. 23100/-",1450,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BY19*31/100","v":0},{"$f":"BY19*28/100","v":0},0,0,0]
[null,8,"2022-10-01",43600,14824,3924,"",null,null,null,{"$f":"SUM(D20:J20)","v":62348},2000,0,658,{"$f":"O19","v":7000},{"$f":"P19","v":0},100,null,null,null,0,{"$f":"SUM(L20:U20)","v":9758},52590,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"}},62348,5842,null,"B","LIBRARIAN",3,"B",null,"L-5","18001 TO 33500",null,341,349,402,440,402,440,220,440,null,null,null,null,null,null,null,43600,null,null,null,null,null,null,null,null,null,2,"Rs. 23101/- to 28500/-",1625,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CB16:CB19)","v":3807},{"$f":"ROUND(SUM(CC17:CC19),0)","v":254},{"$f":"ROUND(SUM(CD17:CD19),0)","v":2284},1412,{"$f":"CD20-CE20","v":872}]
[null,9,"2022-11-01",43600,{"$f":"IF($I$3=\"REGULAR\",ROUND((D21*38/100),0),0)","v":16568},3924,"",null,null,null,64092,2000,0,658,{"$f":"O20","v":7000},0,{"$f":"Q20","v":100},null,null,null,0,9758,54334,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"}},64092,6017,null,"B","A.A.O.",3,"B",null,"L-6","33501 TO 54000",null,511,522,602,658,602,658,330,658,null,null,null,null,null,null,null,43600,null,null,null,null,null,null,null,null,null,3,"Rs. 28501/- to 38500/-",2100,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17","v":43600},{"$f":"BY21*38/100","v":16568},{"$f":"BY21*34/100","v":14824},{"$f":"BZ21-CA21","v":1744}]
[null,10,"2022-12-01",43600,{"$f":"IF($I$3=\"REGULAR\",ROUND((D22*38/100),0),0)","v":16568},3924,"",null,null,null,64092,2000,0,658,{"$f":"O21","v":7000},{"$f":"P21","v":0},100,null,null,null,0,9758,54334,null,null,{"$error":"#N/A"},64092,6017,null,"B","SENIOR ASSISTANT",3,"B",null,"L-7","54001 & ABOVE",null,680,695,800,875,800,875,440,875,null,null,null,null,null,null,null,43600,null,null,null,null,null,null,null,null,null,4,"Rs. 38501/- to 51500/-",2850,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18","v":43600},{"$f":"BY22*38/100","v":16568},{"$f":"BY22*34/100","v":14824},{"$f":"BZ22-CA22","v":1744}]
[null,11,"2023-01-01",43600,{"$f":"IF($I$3=\"REGULAR\",ROUND((D23*38/100),0),0)","v":16568},3924,"",null,null,null,64092,2000,0,658,{"$f":"O21","v":7000},{"$f":"P21","v":0},100,null,null,null,0,9758,54334,null,null,{"$error":"#N/A"},64092,6017,null,"C","JUNIOR ASSISTANT",2,"C",null,"L-8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43600,null,null,null,null,null,null,null,null,null,5,"Rs. 51501/- to 62000/-",3575,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D19","v":43600},16568,14824,1744]
[null,12,"2023-02-01",43600,16568,3924,"",null,null,null,64092,2000,0,658,{"$f":"O23","v":7000},{"$f":"P23","v":0},100,null,null,null,0,9758,54334,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"}},64092,6017,null,null,"OFFICE ASSISTANT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43600,null,null,null,null,null,null,null,null,null,6,"Rs. 62001/- to 72000/-",4200,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D20","v":43600},{"$f":"BY24*38/100","v":16568},{"$f":"BY24*34/100","v":14824},{"$f":"BZ24-CA24","v":1744}]
[null,13,"SURRENDER",{"$f":"IF(P4=\"yes\",AN26,IF(P4>=\"No\",0))","v":21150},{"$f":"IF(P4=\"YES\",VLOOKUP(W4,SDA,6,0),0)","v":3596},null,null,null,null,null,24746,null,null,null,null,null,null,null,null,null,null,0,24746,null,null,null,null,2475,null,null,null,null,null,null,null,{"$f":"IF(18000>$W$9,AP19,IF(33500>$W$9,AP20,IF(54000>$W$9,AP21,IF(,54001<$W$9,AP22))))","v":602},{"$f":"ISNUMBER(AJ25)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Rs. 72001/- to 80000/-",4800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CB21:CB24)","v":6976}]
[null,14,"DA(JAN-MAR22)",null,{"$f":"CB20","v":3807},null,null,null,null,null,{"$f":"SUM(D26:J26)","v":3807},{"$f":"K26","v":3807},null,null,null,null,null,null,null,0,null,3807,0,null,null,null,null,381,null,null,null,null,null,null,null,{"$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":21150},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Rs. 80001/- to 116000/-",6150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CB24","v":1744}]
[null,15,"DA(JULY-OCT22)",null,{"$f":"CB25","v":6976},null,null,null,null,null,6976,{"$f":"CB27","v":5232},null,null,null,null,null,null,null,null,null,5232,1744,null,null,null,null,698,null,{"$f":"W9*5/100*6","v":12690},null,{"$f":"ROUND(AC13,0)","v":6618},{"$f":"ROUND(AC14,0)","v":3971},{"$f":"ROUND(AC15,0)","v":2647},null,{"$f":"IF(18000>W9,AR19,IF(33500>W9,AR20,IF(54000>W9,AR21,IF(,54000<W9,AR22))))","v":330},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Rs. 116001/- to 167000/-",8900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CB25-CB24","v":5232}]
[null,16,"BONUS",null,null,null,null,null,{"$f":"AD33","v":6774},null,6774,{"$f":"ROUND(K28*25/100,0)","v":1694},null,null,null,null,null,null,null,0,null,{"$f":"SUM(L28:U28)","v":1694},{"$f":"K28-V28","v":5080},null,null,null,null,null,null,{"$f":"W9*5/100*2","v":4230},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K32+L32","v":823483},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"167001/- and Above",10500]
[null,17,"SALARY ARREAR",null,null,null,null,null,null,null,{"$f":"SUM(D29:J29)","v":0},null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,"PRINCIPAL","A",5,null,"L-1",700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K28/2","v":3387}]
[null,18,"SALARY ARREAR",null,null,null,null,null,null,null,{"$f":"SUM(D30:J30)","v":0},null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"L-2",700]
[null,19,"SALARY ARREAR",null,null,null,null,null,null,null,0,{"$f":"IF($W$2=\"yes\",AB31,IF($W$2=\"no\",\"  \"))","v":0},null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,0,{"$f":"SUM(U25:U31)","v":0},null,null,"HEAD MASTER ","A",5,null,"L-3",700]
[null,null,"TOTAL",{"$f":"SUM(D13:D31)","v":539150},{"$f":"SUM(E13:E31)","v":196206},46620,0,0,6774,0,788750,{"$f":"SUM(L13:L31)","v":34733},0,7896,{"$f":"SUM(O13:O31)","v":84000},0,1200,0,0,0,{"$f":"SUM(U13:U31)","v":0},{"$f":"SUM(V13:V31)","v":127829},{"$f":"SUM(W13:W31)","v":660921},null,null,null,null,null,null,{"$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,null,"L-4",700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD33-AC33","v":5080},{"$f":"ROUND(AD33*25/100,0)","v":1694},{"$f":"IF(W3=\"YES\",6774,IF(W3=\"NO\",\" \"))","v":6774},null,"SENOIR TEACHER (II Gr.)","B",3,null,"L-5",700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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,null,"L-6",700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC33-AC34","v":339},null,null,"TEACHER (III Gr.) Level 2","B",3,null,"L-7",700]
[null,null,"Signature of Employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature of DDO",null,null,null,null,null,null,null,null,null,null,null,"TEACHER (III Gr.) Level 1","B",3,null,"L-8",800]
[null,null,{"$f":"D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,null,null,null,null,"vijay prajapat excel programmer9828120697",null,null,null,null,null,null,null,null,null,{"$f":"F6","v":"श्री करमा राम"},null,null,null,null,null,null,null,null,null,null,null,"PET (I Gr.)","A",5,null,"L-9",800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PET (II Gr.)","B",3,null,"L-10",1100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PET ( III Gr.)","B",3,null,"L-11",1100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," SPECIAL TEACHER (III Gr.) Level 1","B",3,null,"L-12",1400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," SPECIAL TEACHER (III Gr.) Level 2","B",3,null,"L-13",1400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIBRARIAN ( I Gr.)","A",5,null,"L-14",1400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIBRARIAN ( II Gr.)","B",3,null,"L-15",1800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIBRARIAN ( III Gr.)","B",3,null,"L-16",2100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAB. ASSISTANT (II Gr.)","B",3,null,"L-17",2100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAB. ASSISTANT (II Gr.)","B",3,null,"L-18",2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAB BOY","C",2,null,"L-19",2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COACH","A",5,null,"L-20",3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A.A.O.","B",3,null,"L-21",3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENIOR ASSISTANT(UDC)","B",3,null,"L-22",4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUNIOR ASSISTANT (LDC)","B",3,null,"L-23",4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFICE ASSISTANT ( PEON )","C",2,null,"L-24",5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRABODHAK ( III Gr.) LEVEL 1","B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRABODHAK ( III Gr.) LEVEL 2","B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRABODHAK PET.( III Gr.) LEVEL 1","B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]

{"sheet":"7pay matrix chart","index":2,"n_rows":48,"n_cols":31,"rows_kept":48,"cut":false,"hidden":false,"merged":[[22,23,25,24],[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],[34,21,34,22],[34,25,34,26],[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],[35,21,35,22],[35,25,35,26],[36,21,36,22],[36,25,36,26],[37,21,37,22],[37,25,37,26],[38,21,38,24],[38,25,38,26],[39,21,39,22],[40,19,41,20],[37,20,39,20],[40,21,40,22],[41,21,41,22],[42,21,42,22],[43,21,43,22],[44,21,44,30],[45,16,47,20],[44,17,44,20],[42,18,43,20]]}
["SCHEDULE-1 PART-B RULE NO.5 VI & VII",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHEDULE IV  (RULE NO. 16"]
["PAY MATRIX OF STATE GOVT. SERVANTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIX REMUNERATION FOR PROBATIONER-TRAINEE"]
["EXISTING R.P. BAND","                                  PB-1                                       5200-20000",null,null,null,null,null,null,null,null,"              PB -2                    9300-34800",null,null,null,"                             PB-3                                 15600-39100",null,null,null,null,null,null,"                 PB -4                  37400-67000",null,null,null,"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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,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",null,null,null,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",null,null,null,"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,null,null,null,"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,null,null,null,"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,null,null,null,null,"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",null,null,null,null,"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,null,null,null,null,null,"RATE",0.04,0.05,7.0000000000000007E-2,0.09,0.12,0.17,0.28000000000000003]
[40,{"$f":"ROUND(B47+(B47*0.03),-2)","v":56200},56800,57900,60800,65900,68000,71200,83500,91300,106700,119700,140100,167800,177500,192000,null,null,null,null,null,"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,"cut":false,"hidden":false,"merged":[[0,9,0,11],[15,3,15,6],[17,3,17,6],[0,0,0,1],[1,5,1,6],[1,3,1,4],[0,3,0,6],[14,0,16,1],[16,5,16,6]]}
["ENTER DATA IN YELLOW TAB",null,null,"TAX CACULATION",null,null,null,null,null,"TAX SLAB ( YEAR 2021-22)"]
["ANNUAL GROSS SALARY",{"$f":"'GA55'!K32","v":788750},null,"OLD TAX REGIME",null,"NEW TAX REGIME  ( OPTIONAL)",null,null,null,"SLAB","OPTIONAL","EXITING"]
["STANDARD DEDUCTION",50000,null,"SLAB AMOUNT (OLD)","TAX","SLAB AMOUNT (NEW)","TAX",null,null,null,"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",0,0]
["PT AND ENTERTAINMENT ALLOWANCE",0,null,{"$f":"IF($B$13>500000,250000,$B$13-D4)","v":229017},{"$f":"IF(B13<=500000,0,(D5*L5))","v":0},{"$f":"IF($B$14>500000,250000,($B$14-F4))","v":250000},{"$f":"IF(B14<=500000,0,F5*K5)","v":12500},null,null,"250001-500000",0.05,0.05]
["GPF/NPS/GPF04",{"$f":"'GA55'!L32","v":34733},null,{"$f":"IF($B$13>750000,250000,$B$13-D5-D4)","v":0},{"$f":"ROUND(D6*L6,0)","v":0},{"$f":"IF($B$14>750000,250000,($B$14-F5-F4))","v":250000},{"$f":"ROUND(F6*K6,0)","v":25000},null,null,"500001-750000",0.1,0.2]
["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":4017},{"$f":"ROUND(F7*K7,0)","v":603},null,null,"750001-1000000",0.15,0.2]
["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",0.2,0.3]
["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",0.25,0.3]
["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",0.3,0.3]
["80U",75000]
["TOAL EXEMPTION & DEDUCTION",{"$f":"B3+B4+B5+B6+B7+B8+B9+B10+B11","v":309733},null,"TOTAL",{"$f":"ROUND(SUM(E4:E11),0)","v":0},null,{"$f":"SUM(G4:G11)","v":38103}]
["TEXABLE INCOME for exiting slab",{"$f":"B2-B12","v":479017},null,"S.& EDU.TAX",{"$f":"ROUND(E12*4/100,0)","v":0},{"$f":"-D18","v":0},{"$f":"ROUND(G12*4/100,0)","v":1524}]
["In new income tax nps exemption",{"$f":"B2-B6","v":754017},null,{"$f":"SUM(D4:D11)","v":479017},{"$f":"ROUND(E12+E13,0)","v":0},{"$f":"SUM(F4:F11)","v":754017},{"$f":"ROUND((G12+G13),0)","v":39627}]
["   पीले CELL में कटौती लिखे                       ध्यान रहे एक बार NEW TAX REGIME लेने पर आगामी वर्षों में यही रहेगा ",null,null,"TOTAL TAX",{"$f":"ROUND(E14,0)","v":0},"TOTAL TAX",{"$f":"ROUND(G14,0)","v":39627}]
[null,null,null,"WHICH IS BETTER FOR YOU ?"]
[null,null,null,{"$f":"IF(G15>E15,\"OLD IS BETTER\",\"NEW IS BETTER\")","v":"OLD IS BETTER"},"FOR",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"}]
[]
[]
[]
[]
[null,null,null,{"$f":"B2","v":788750},{"$f":"B13-250000","v":229017},null,null,{"$f":"B13","v":479017},250000,{"$f":"H22-I22","v":229017},{"$f":"B2","v":788750},250000,{"$f":"K22-L22","v":538750}]
[null,null,null,{"$f":"SUM(B3:B7)","v":84733},null,null,{"$f":"IF(E5>=12500,\"0\",IF(E5>=12500,(E5-12500)))","v":false},{"$f":"J22","v":229017},250000,{"$f":"H23-I23","v":-20983},{"$f":"M22","v":538750},250000,{"$f":"K23-L23","v":288750}]
[null,null,null,{"$f":"D22-D23","v":704017},null,null,null,null,null,null,{"$f":"M23","v":288750},250000,38750]
[null,null,null,{"$f":"SUM(B8:B11)","v":225000},null,null,null,null,null,null,null,250000,-250000]
[null,null,null,{"$f":"D24-D25","v":479017},{"$f":"B13-250000","v":229017}]
[]
[null,null,null,0]

{"sheet":"OLD TAX REGIME","index":4,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[51,2,51,10],[52,2,52,10],[53,2,53,10],[54,2,54,10],[55,2,55,10],[13,5,13,6],[56,1,56,12],[57,2,57,4],[50,2,50,10],[23,3,23,4],[38,1,38,10],[30,1,37,1],[39,2,39,10],[40,2,40,10],[26,2,26,10],[27,2,27,10],[28,2,28,10],[15,1,28,1],[29,1,29,12],[24,3,24,4],[24,6,24,9],[25,2,25,11],[16,12,24,12],[15,3,15,10],[63,2,63,10],[64,2,64,10],[65,2,65,10],[60,9,60,10],[61,9,61,10],[62,9,62,10],[57,12,59,12],[61,12,62,12],[60,2,60,4],[61,2,61,4],[62,2,62,4],[57,6,57,8],[58,6,58,8],[59,6,59,8],[60,6,60,8],[61,6,61,8],[62,6,62,8],[12,7,12,8],[10,7,10,8],[13,3,13,4],[13,7,13,8],[23,7,23,9],[20,7,20,9],[21,7,21,9],[22,7,22,9],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[13,9,13,10],[2,11,2,12],[14,3,14,10],[3,3,3,4],[3,5,3,7],[9,3,9,10],[0,1,0,12],[5,3,5,10],[4,3,4,10],[6,3,6,10],[7,1,8,1],[7,3,7,9],[8,3,8,9],[2,8,2,9],[3,8,3,9],[3,10,3,12],[2,4,2,6],[7,12,8,12],[1,1,1,9],[1,10,1,12],[10,1,12,1],[11,3,12,4],[11,5,11,6],[12,5,12,6],[11,7,11,8],[30,3,30,10],[31,3,31,10],[32,3,32,10],[33,3,33,10],[42,2,42,7],[42,8,42,10],[35,3,35,10],[36,3,36,10],[37,3,37,10],[34,3,34,10],[70,3,70,5],[67,3,67,5],[43,1,48,1],[43,8,43,10],[46,2,46,6],[47,2,47,6],[48,2,48,6],[41,2,41,10],[43,2,43,6],[44,2,44,6],[45,2,45,6],[44,8,44,10],[45,8,45,10],[46,8,46,10],[47,8,47,10],[48,8,48,10],[49,2,49,7],[49,8,49,10],[58,2,58,4],[59,2,59,4],[57,9,57,10],[58,9,58,10],[59,9,59,10],[67,10,67,12]]}
[null,{"$f":"'GA55'!B7","v":"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR"}]
[null,"आयकर गणना प्रपत्र 202-23 ( कर निर्धारण वर्ष 202-24)",null,null,null,null,null,null,null,null,"OLD TAX REGIME"]
[null,1,null,"नाम कर्मचारी",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,"पद",{"$f":"'GA55'!I9:K9","v":"LECTURER"},null,"PAN NO",{"$f":"'GA55'!O9","v":"QYPP0000J"}]
[null,null,null,"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 सहित )",null,null,null,null,null,null,null,"Rs.",{"$f":"'GA55'!K32","v":788750}]
[null,3,null,"ग्रह किराया धारा 10(13-I) के अंतर्गतएंव धारा 10(14) के अंतर्गतअन्यभत्ते जो करमुक्त हो",null,null,null,null,null,null,null,"Rs.",0]
[null,4,null,"शेष (2-3) -WITH EXEMPT STANDARD DEDUCTION MAX. 50000",null,null,null,null,null,null,null,"Rs.",{"$f":"M5-M6-50000","v":738750}]
[null,5,null,"(i) मनोरंजन भत्ता धारा 16(i) के अंतर्गत ( अधिकतम सीमा रू 5000 )",null,null,null,null,null,null,0,"Rs."]
[null,null,null,"(ii)  व्यवसाय कर धारा 16(ii) के अंतर्गत ( अधिकतम सीमा रू 5000 )",null,null,null,null,null,null,0,"Rs."]
[null,6,null,"शेष (4-5) ",null,null,null,null,null,null,null,"Rs.",{"$f":"M7-K8-K9","v":738750}]
[null,7,null,"(अ) ग्रह सम्पति से आय (1) स्वंय के उपयोग में - शून्य",null,null,null,null,null,"(2) प्राप्त किराया रू",null,"Rs."]
[null,null,null,"(ब) घटाए",null,"किराये का 30%",null,"ग्रह ऋण पर ब्याज",null,"गृहकर","योग 7 (ब)","Rs."]
[null,null,null,null,null,0,null,0,null,0,{"$f":"F13+H13+I13+J13+G13","v":0},"Rs."]
[null,8,null,"बचत खाते पर ब्याज",null,0,null,"9 .  अन्य आय",null,0]
[null,null,null,"कुल सकल आय",null,null,null,null,null,null,null,"Rs.",{"$f":"M10-K13+F14+J14","v":738750}]
[null,10,"(A)","Chapter VI A Deductions( max 150000) ",null,null,null,null,null,null,null,"Rs."]
[null,null,"(i)",{"$f":"'GA55'!L12","v":"GPF4"},null,{"$f":"'GA55'!L32","v":34733},"(x)","FIXED DEPOSIT 5 YEAR",null,null,0,"Rs."]
[null,null,"(ii)","SI",null,{"$f":"'GA55'!O32","v":84000},"(xi)","TUSION FEES",null,null,0,"Rs."]
[null,null,"(iii)","LIC ( from salary)",null,{"$f":"'GA55'!Q32","v":1200},"(xii)","NPS CONTRIBUTION ",null,null,{"$f":"M27-M28","v":0},"Rs."]
[null,null,"(iv)","LIC ( by Self)",null,12000,"(xiii)","PENSION PLAN (US 80CCC)",null,null,0,"Rs."]
[null,null,"(v)","PPF",null,0,"(xiv)","DEFFERED ANNUTY",null,null,0,"Rs."]
[null,null,"(vi)","PLI",null,0,"(xv)","ULIP",null,null,0,"Rs."]
[null,null,"(vii)","NSC",null,0,"(xvi)","GIS",null,null,{"$f":"'GA55'!R14","v":0},"Rs."]
[null,null,"(viii)","HBA Premium",null,0,"(xvii)","सुकन्या समृद्धि योजना",null,null,0,"Rs."]
[null,null,"(ix)","NSS",null,0,"Total( I to xvii)",null,null,null,{"$f":"F17+F18+F19+F20+F22+F21+F23+F24+F25+K17+K18+K19+K20+K21+K22+K23+K24","v":131933},"Rs."]
[null,null,"अधिकतम कटोती की राशि 1.50 लाख रूपये तक",null,null,null,null,null,null,null,null,null,{"$f":"IF(K25<=150000,K25,150000)","v":131933}]
[null,null,"धारा 80CCD(2) नियोक्ता द्वारा वेतन अंशदान की राशि ( अधिकतम वेतन का 10% ) पृथक से छूट ",null,null,null,null,null,null,null,null,"Rs.",0]
[null,null,"धारा 80CCD(1B) नियोक्ता द्वारा नवीन पेंशन योजना में अतिरिक्त अंशदान की राशि ( अधिकतम 50000 ) पृथक से छूट ",null,null,null,null,null,null,null,null,"Rs."]
[null,null,"योग 8 (अ + ब + स )",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M26+M27+M28","v":131933}]
[null,"अन्य कटौतियां (VI A)-US80D,US80DD,US80DDB,US80E,US80G,US80GG,80U,80TTA etc."]
[null,11,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.",0]
[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.",0]
[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.",0]
[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.",0]
[null,null,5,"धारा 80G -  धर्मार्थ संस्थाओं को दिए गए दान ( क श्रेणी 100% एंव ख श्रेणी 50 % )",null,null,null,null,null,null,null,"Rs.",0]
[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."]
[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.",0]
[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.",0]
[null,"कुल योग ( 1 से 8 तक )",null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"M31+M32+M33+M34+M35+M36+M37+M38","v":0}]
[null,12,"कुल कटौती",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M29+M39","v":131933}]
[null,13,"कर योग्य आय",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M15-M40","v":606817}]
[null,14,"कुल आय की राशि का 10 के गुणांक में गणना",null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND(M41,-1)","v":606820}]
[null,15,"सामान्य आयकर स्लैब",null,null,null,null,null,"आयकर योग्य राशि"]
[null,null,"0    - 2,50,000 ","0-250000","0-250000","0-250000","0-250000",0,{"$f":"IF($M$42>250000,250000,$M$42)","v":250000},null,null,"Rs.",{"$f":"I44*H44","v":0}]
[null,null,"2,50,001       -     5,00,000","250001-500000","250001-500000","250001-500000","250001-500000",0.05,{"$f":"IF($M$42>500000,250000,$M$42-I44)","v":250000},null,null,"Rs.",{"$f":"I45*H45","v":12500}]
[null,null,"5,00,001     -      10,00,000","500001-750000","500001-750000","500001-750000","500001-750000",0.2,{"$f":"IF($M$42>1000000,500000,$M$42-I44-I45)","v":106820},null,null,"Rs.",{"$f":"I46*H46","v":21364}]
[null,null,"10,00,001  -        12,50,000","1000001-1250000","1000001-1250000","1000001-1250000","1000001-1250000",0.3,{"$f":"IF($M$42>1250000,250000,$M$42-I46-I45-I44)","v":0},null,null,"Rs.",0]
[null,null,"12,50,001    -      15,00,000","1250001-1500000","1250001-1500000","1250001-1500000","1250001-1500000",0.3,{"$f":"IF($M$42>1500000,250000,$M$42-I47-I46-I45-I44)","v":0},null,null,"Rs.",0]
[null,null," Above 15,00,000","1250001-1500000","1250001-1500000","1250001-1500000","1250001-1500000",0.3,{"$f":"IF($M$42<1500000,0,$M$42-I48-I47-I46-I44-I45)","v":0},null,null,"Rs.",0]
[null,16,"योग आयकर",null,null,null,null,null,{"$f":"I44+I45+I46+I47+I48+I49","v":606820},null,null,"Rs.",{"$f":"M44+M45+M46+M47+M48+M49","v":33864}]
[null,17,"धारा 87 (A) - ( 2.50 लाख से 5.00 लाख तक की कर योग्य आय पर अधिकतम छूट 12500 रूपये",null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(M42<=500000,M45,0)","v":0}]
[null,18,"छूट के पश्चात् कुल आयकर",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M50-M51","v":33864}]
[null,19,"शिक्षा उपकर 2% एंव उच्च शिक्षा के लिए अधिभार 2%  TOTAL 4%",null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND(M52*4%,0)","v":1355}]
[null,20,"कुल आयकर",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M52+M53","v":35219}]
[null,21,"राहत धारा 89 के तहत छूट ",null,null,null,null,null,null,null,null,"Rs.",0]
[null,22,"कुल शेष आयकर",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M54-M55","v":35219}]
[null,"विभिन्न स्रोतों से हुई मासिक आयकर कटौती"]
[null,null,{"$f":"'GA55'!C13","v":"2022-03-01"},null,null,{"$f":"'GA55'!U13","v":0},{"$f":"'GA55'!C19","v":"2022-09-01"},null,null,{"$f":"'GA55'!U19","v":0},null,"Rs.","अन्य एरियर से कटौती"]
[null,null,{"$f":"'GA55'!C14","v":"2022-04-01"},null,null,{"$f":"'GA55'!U14","v":0},{"$f":"'GA55'!C20","v":"2022-10-01"},null,null,{"$f":"'GA55'!U20","v":0},null,"Rs."]
[null,null,{"$f":"'GA55'!C15","v":"2022-05-01"},null,null,{"$f":"'GA55'!U15","v":0},{"$f":"'GA55'!C21","v":"2022-11-01"},null,null,{"$f":"'GA55'!U21","v":0},null,"Rs."]
[null,null,{"$f":"'GA55'!C16","v":"2022-06-01"},null,null,{"$f":"'GA55'!U16","v":0},{"$f":"'GA55'!C22","v":"2022-12-01"},null,null,{"$f":"'GA55'!U22","v":0},null,"Rs.",{"$f":"SUM('GA55'!U25:U31)","v":0}]
[null,null,{"$f":"'GA55'!C17","v":"2022-07-01"},null,null,{"$f":"'GA55'!U17","v":0},{"$f":"'GA55'!C23","v":"2023-01-01"},null,null,{"$f":"'GA55'!U23","v":0},null,"Rs."]
[null,null,{"$f":"'GA55'!C18","v":"2022-08-01"},null,null,{"$f":"'GA55'!U18","v":0},{"$f":"'GA55'!C24","v":"2023-02-01"},null,null,{"$f":"'GA55'!U24","v":0},null,"Rs."]
[null,null," कुल  कटौती का योग",null,null,null,null,null,null,null,null,"Rs.",{"$f":"F58+F59+F60+F61+F62+F63+J58+J59+J60+J61+J62+J63+M61","v":0}]
[null,null,"Income tax Refundable",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M64-M56","v":-35219}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"हस्ताक्षर कर्मचारी/ अधिकारी"]

{"sheet":"NEW TAX REGIME","index":5,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":false,"merged":[[50,2,50,7],[50,8,50,10],[66,2,66,10],[68,10,68,12],[48,2,48,6],[48,8,48,10],[62,12,63,12],[63,2,63,4],[63,6,63,8],[63,9,63,10],[64,2,64,10],[65,2,65,10],[60,9,60,10],[61,2,61,4],[61,6,61,8],[61,9,61,10],[62,2,62,4],[62,6,62,8],[62,9,62,10],[57,1,57,12],[58,2,58,4],[58,6,58,8],[58,9,58,10],[58,12,60,12],[59,9,59,10],[60,2,60,4],[60,6,60,8],[51,2,51,10],[59,2,59,4],[59,6,59,8],[52,2,52,10],[53,2,53,10],[54,2,54,10],[55,2,55,10],[56,2,56,10],[47,8,47,10],[49,2,49,6],[49,8,49,10],[42,2,42,7],[42,8,42,10],[43,1,49,1],[43,2,43,6],[43,8,43,10],[44,2,44,6],[44,8,44,10],[46,2,46,6],[46,8,46,10],[47,2,47,6],[45,2,45,6],[45,8,45,10],[36,3,36,10],[37,3,37,10],[38,1,38,10],[39,2,39,10],[40,2,40,10],[41,2,41,10],[27,2,27,10],[28,2,28,10],[29,1,29,12],[30,1,37,1],[30,3,30,10],[31,3,31,10],[32,3,32,10],[33,3,33,10],[34,3,34,10],[35,3,35,10],[15,1,28,1],[15,3,15,10],[16,3,16,4],[16,7,16,9],[16,12,24,12],[17,3,17,4],[17,7,17,9],[18,3,18,4],[23,3,23,4],[23,7,23,9],[24,3,24,4],[24,6,24,9],[25,2,25,11],[26,2,26,10],[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],[18,7,18,9],[19,3,19,4],[9,3,9,10],[10,1,12,1],[10,12,12,12],[11,3,12,4],[14,3,14,10],[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],[10,7,10,8],[11,5,11,6],[11,7,11,8],[12,5,12,6],[12,7,12,8],[13,3,13,4],[13,7,13,8],[13,9,13,10],[13,5,13,6],[0,1,0,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],[1,1,1,9],[1,10,1,12]]}
[null,{"$f":"'GA55'!B7","v":"OFFICE GOVT.SR.SEC.SCHOOL ALNIYAWAS DISTT.-NAGAUR"}]
[null,"आयकर गणना प्रपत्र 2021-22 ( कर निर्धारण वर्ष 2022-23)",null,null,null,null,null,null,null,null,"NEW TAX REGIME"]
[null,1,null,"नाम कर्मचारी",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,"पद",{"$f":"'GA55'!J9","v":0},null,"PAN NO",{"$f":"'GA55'!O9","v":"QYPP0000J"}]
[null,null,null,"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 सहित )",null,null,null,null,null,null,null,"Rs.",{"$f":"'GA55'!K32","v":788750}]
[null,3,null,"ग्रह किराया धारा 10(13-I) के अंतर्गतएंव धारा 10(14) के अंतर्गतअन्यभत्ते जो करमुक्त हो",null,null,null,null,null,null,null,"Rs.",0]
[null,4,null,"शेष (2-3) -WITH EXEMPT STANDARD DEDUCTION MAX. 50000",null,null,null,null,null,null,null,"Rs.",{"$f":"M5-M6-50000","v":738750}]
[null,5,null,"(i) मनोरंजन भत्ता धारा 16(i) के अंतर्गत ( अधिकतम सीमा रू 5000 )",null,null,null,null,null,null,0,"Rs."]
[null,null,null,"(ii)  व्यवसाय कर धारा 16(ii) के अंतर्गत ( अधिकतम सीमा रू 5000 )",null,null,null,null,null,null,0,"Rs."]
[null,6,null,"शेष (4-5) ",null,null,null,null,null,null,null,"Rs.",{"$f":"M7-K8-K9","v":738750}]
[null,7,null,"(अ) ग्रह सम्पति से आय (1) स्वंय के उपयोग में - शून्य",null,null,null,null,null,"(2) प्राप्त किराया रू",null,"Rs."]
[null,null,null,"(ब) घटाए",null,"किराये का 30%",null,"ग्रह ऋण पर ब्याज",null,"गृहकर","योग 7 (ब)","Rs."]
[null,null,null,null,null,0,null,0,null,0,{"$f":"F13+H13+I13+J13+G13","v":0},"Rs."]
[null,null,null,"बचत खाते पर ब्याज",null,0,null,"9 .   अन्य आय",null,0]
[null,null,null,"कुल सकल आय",null,null,null,null,null,null,null,"Rs.",{"$f":"M10-K13+F14+J14","v":738750}]
[null,10,"(A)","Chapter VI A Deductions( max 150000) ",null,null,null,null,null,null,null,"Rs."]
[null,null,"(i)","GPF",null,{"$f":"'GA55'!M32","v":0},"(x)","FIXED DEPOSIT 5 YEAR",null,null,0,"Rs."]
[null,null,"(ii)","SI",null,0,"(xi)","TUSION FEES",null,null,0,"Rs."]
[null,null,"(iii)","LIC ( from salary)",null,0,"(xii)","NPS CONTRIBUTION ",null,null,0,"Rs."]
[null,null,"(iv)","LIC ( by Self)",null,0,"(xiii)","PENSION PLAN (US 80CCC)",null,null,0,"Rs."]
[null,null,"(v)","PPF",null,0,"(xiv)","DEFFERED ANNUTY",null,null,0,"Rs."]
[null,null,"(vi)","PLI",null,0,"(xv)","ULIP",null,null,0,"Rs."]
[null,null,"(vii)","NSC",null,0,"(xvi)","GIS",null,null,0,"Rs."]
[null,null,"(viii)","HBA Premium",null,0,"(xvii)","सुकन्या समृद्धि योजना",null,null,0,"Rs."]
[null,null,"(ix)","NSS",null,0,"Total( I to xvii)",null,null,null,0,"Rs."]
[null,null,"अधिकतम कटोती की राशि 1.50 लाख रूपये तक",null,null,null,null,null,null,null,null,null,{"$f":"IF(K25<=150000,K25,150000)","v":0}]
[null,null,"धारा 80CCD(2) नियोक्ता द्वारा वेतन अंशदान की राशि ( अधिकतम वेतन का 10% ) पृथक से छूट ",null,null,null,null,null,null,null,null,"Rs.",{"$f":"K19","v":0}]
[null,null,"धारा 80CCD(1B) नियोक्ता द्वारा नवीन पेंशन योजना में अतिरिक्त अंशदान की राशि ( अधिकतम 50000 ) पृथक से छूट ",null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(K27<=150000,K27,150000)","v":0}]
[null,null,"योग 8 (अ + ब + स )",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M26+M27+M28","v":0}]
[null,"अन्य कटौतियां (VI A)-US80D,US80DD,US80DDB,US80E,US80G,US80GG,80U,80TTA etc."]
[null,11,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.",0]
[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.",0]
[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.",0]
[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.",0]
[null,null,5,"धारा 80G -  धर्मार्थ संस्थाओं को दिए गए दान ( क श्रेणी 100% एंव ख श्रेणी 50 % )",null,null,null,null,null,null,null,"Rs.",{"$f":"K35+I35","v":0}]
[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.",0]
[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.",0]
[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.",0]
[null,"कुल योग ( 1 से 8 तक )",null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"M31+M32+M33+M34+M35+M36+M37+M38","v":0}]
[null,12,"कुल कटौती",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M29+M39","v":0}]
[null,13,"कर योग्य आय",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M15-M40","v":738750}]
[null,14,"कुल आय की राशि का 10 के गुणांक में गणना",null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND(M41,-1)","v":738750}]
[null,15,"सामान्य आयकर स्लैब",null,null,null,null,null,"आयकर योग्य राशि"]
[null,16,"0    - 2,50,000 ","0-250000","0-250000","0-250000","0-250000",0,{"$f":"IF($M$42>250000,250000,$M$42)","v":250000},null,null,"Rs.",{"$f":"I44*H44","v":0}]
[null,null,"2,50,001       -     5,00,000","250001-500000","250001-500000","250001-500000","250001-500000",0.05,{"$f":"IF($M$42>500000,250000,$M$42-I44)","v":250000},null,null,"Rs.",{"$f":"ROUND(I45*H45,0)","v":12500}]
[null,null,"5,00,001       -     7,50,000","250001-500000","250001-500000","250001-500000","250001-500000",0.1,{"$f":"IF($M$42>500000,250000,$M$42-I45)","v":250000},null,null,"Rs.",{"$f":"ROUND(I46*H46,0)","v":25000}]
[null,null,"7,50,001     -      10,00,000","500001-750000","500001-750000","500001-750000","500001-750000",0.15,{"$f":"IF($M$42>1000000,500000,$M$42-I44-I45)","v":238750},null,null,"Rs.",{"$f":"ROUND(I47*H47,0)","v":35813}]
[null,null,"10,00,001  -        12,50,000","1000001-1250000","1000001-1250000","1000001-1250000","1000001-1250000",0.2,{"$f":"IF($M$42>1250000,500000,$M$42-I45-I47-I44)","v":0},null,null,"Rs.",{"$f":"I48*H48","v":0}]
[null,null,"12,50,001  -        15,00,000","1000001-1250000","1000001-1250000","1000001-1250000","1000001-1250000",0.25,{"$f":"IF($M$42>1500000,250000,$M$42-I47-I48-I45-I44)","v":0},null,null,"Rs.",0]
[null,null," Above 15,00,000","1250001-1500000","1250001-1500000","1250001-1500000","1250001-1500000",0.3,{"$f":"IF($M$42<1500000,,$M$42-I48-I49-I47-I45-I44)","v":0},null,null,"Rs.",0]
[null,17,"योग आयकर",null,null,null,null,null,{"$f":"I45+I46+I47+I48+I49+I50","v":738750},null,null,"Rs.",{"$f":"SUM(M44:M50)","v":73313}]
[null,18,"धारा 87 (A) - ( 2.50 लाख से 5.00 लाख तक की कर योग्य आय पर अधिकतम छूट 12500 रूपये",null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(M42<=500000,M45,0)","v":0}]
[null,19,"छूट के पश्चात् कुल आयकर",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M51-M52","v":73313}]
[null,20,"शिक्षा उपकर 2% एंव उच्च शिक्षा के लिए अधिभार 2%  TOTAL 4%",null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND(M53*4%,0)","v":2933}]
[null,21,"कुल आयकर",null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND(M53+M54,0)","v":76246}]
[null,22,"राहत धारा 89 के तहत छूट ",null,null,null,null,null,null,null,null,"Rs.",0]
[null,23,"कुल शेष आयकर",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M55-M56","v":76246}]
[null,"विभिन्न स्रोतों से हुई मासिक आयकर कटौती"]
[null,null,{"$f":"'OLD TAX REGIME'!C58:E58","v":"2022-03-01"},null,null,{"$f":"'GA55'!U13","v":0},{"$f":"'OLD TAX REGIME'!G58:I58","v":"2022-09-01"},null,null,{"$f":"'GA55'!U19","v":0},null,"Rs.","अन्य एरियर से कटौती"]
[null,null,{"$f":"'OLD TAX REGIME'!C59:E59","v":"2022-04-01"},null,null,{"$f":"'GA55'!U14","v":0},{"$f":"'OLD TAX REGIME'!G59:I59","v":"2022-10-01"},null,null,{"$f":"'GA55'!U20","v":0},null,"Rs."]
[null,null,{"$f":"'OLD TAX REGIME'!C60:E60","v":"2022-05-01"},null,null,{"$f":"'GA55'!U15","v":0},{"$f":"'OLD TAX REGIME'!G60:I60","v":"2022-11-01"},null,null,{"$f":"'GA55'!U21","v":0},null,"Rs."]
[null,null,{"$f":"'OLD TAX REGIME'!C61:E61","v":"2022-06-01"},null,null,{"$f":"'GA55'!U16","v":0},{"$f":"'OLD TAX REGIME'!G61:I61","v":"2022-12-01"},null,null,{"$f":"'GA55'!U22","v":0},null,"Rs.",{"$f":"SUM('GA55'!U25:U31)","v":0}]
[null,null,{"$f":"'OLD TAX REGIME'!C62:E62","v":"2022-07-01"},null,null,{"$f":"'GA55'!U17","v":0},{"$f":"'OLD TAX REGIME'!G62:I62","v":"2023-01-01"},null,null,{"$f":"'GA55'!U23","v":0},null,"Rs."]
[null,null,{"$f":"'OLD TAX REGIME'!C63:E63","v":"2022-08-01"},null,null,{"$f":"'GA55'!U18","v":0},{"$f":"'OLD TAX REGIME'!G63:I63","v":"2023-02-01"},null,null,{"$f":"'GA55'!U24","v":0},null,"Rs."]
[null,null," कुल  कटौती का योग",null,null,null,null,null,null,null,null,"Rs.",{"$f":"F59+F60+F61+F62+F63+F64+J59+J60+J61+J62+J63+J64+M62","v":0}]
[null,null,"Income tax Refundable",null,null,null,null,null,null,null,null,"Rs.",{"$f":"M57-M65","v":76246}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"हस्ताक्षर कर्मचारी/ अधिकारी"]

{"sheet":"PAY SLIP","index":6,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[42,1,42,5],[42,6,42,9],[26,6,26,7],[27,1,27,2],[45,1,45,2],[43,1,43,5],[43,6,43,9],[30,8,30,9],[32,8,32,9],[33,8,33,9],[36,5,36,6],[45,3,45,4],[35,3,35,4],[36,3,36,4],[33,6,33,7],[30,1,30,2],[30,3,30,4],[30,6,30,7],[32,3,33,4],[32,1,33,2],[28,8,28,9],[29,1,29,2],[29,3,29,4],[29,6,29,7],[29,8,29,9],[28,1,28,2],[28,3,28,4],[28,6,28,7],[32,6,32,7],[31,1,31,2],[27,6,27,7],[27,8,27,9],[22,5,31,5],[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],[31,3,31,4],[31,6,31,7],[31,8,31,9],[21,6,22,9],[27,3,27,4],[26,8,26,9],[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],[5,1,5,3],[5,6,5,7],[7,2,7,5],[7,6,7,7],[4,4,4,6],[19,3,19,9],[11,1,11,2],[11,3,11,5],[11,7,11,9],[15,1,15,2],[15,3,15,5],[15,7,15,9],[17,1,17,3],[17,6,17,8],[13,8,13,9],[13,1,13,3],[13,6,13,7],[7,8,7,9],[21,1,22,4],[37,1,37,2],[37,3,37,9],[34,1,34,4],[34,6,34,9],[9,1,9,3],[9,6,9,8],[25,8,25,9],[23,1,23,2],[23,3,23,4],[23,6,23,7],[23,8,23,9],[26,1,26,2],[26,3,26,4],[19,1,19,2]]}
[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}]
[null,null,null,"Month :","2022-10-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C13","v":"2022-03-01"}]
[null,"कर्मचारी का नाम",null,null,null,null,"पदनाम",null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C14","v":"2022-04-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C15","v":"2022-05-01"}]
[null,"NAME",{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,null,"Designation :",null,{"$f":"'GA55'!I9:K9","v":"LECTURER"},null,null,null,null,null,null,null,{"$f":"'GA55'!C16","v":"2022-06-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C17","v":"2022-07-01"}]
[null,"कर्मचारी पहचान संख्या",null,null,null,null,"बैंक खाता संख्या",null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C18","v":"2022-08-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C19","v":"2022-09-01"}]
[null,"Emp. Id",null,{"$f":"'GA55'!W11","v":"RJNA0000000000"},null,null,"A/C. No.",{"$f":"'GA55'!W10","v":61000000000},null,null,null,null,null,null,null,null,{"$f":"'GA55'!C20","v":"2022-10-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C21","v":"2022-11-01"}]
[null,"जीपीएफ",null,null,null,null,"एसआई नम्बर",null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C22","v":"2022-12-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GA55'!C23","v":"2023-01-01"}]
[null,"GPF/GPF04 No.",null,{"$f":"'GA55'!I10","v":45},null,null,"SI No.",{"$f":"'GA55'!D10","v":457858},null,null,null,null,null,null,null,null,{"$f":"'GA55'!C24","v":"2023-02-01"}]
[]
[null,"बैंक शाखा"]
[]
[null,"Bank/ Branch",null,{"$f":"'GA55'!M10","v":"STATE BANK OF INDIA RIYAN BARI"}]
[]
[null,"INCOME",null,null,null,null,"DEDUCTION"]
[]
[null,"Basic",null,{"$f":"VLOOKUP(E5,ga,2,0)","v":43600},null,null,{"$f":"'GA55'!L12","v":"GPF4"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,10,0)","v":2000}]
[null,"D.A.",null,{"$f":"VLOOKUP($E$5,'GA55'!C13:Y24,3,0)","v":14824},null,null,{"$f":"'GA55'!M12","v":"GPF04 LOAN"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,11,0)","v":0}]
[null,"H.R.A.",null,{"$f":"VLOOKUP($E$5,'GA55'!C13:Y24,4,0)","v":3924},null,null,{"$f":"'GA55'!O12","v":"SIP"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,13,0)","v":7000}]
[null,"Washing Allowance",null,{"$f":"VLOOKUP($E$5,'GA55'!C14:Y25,6,0)","v":0},null,null,{"$f":"'GA55'!P12","v":"SIL"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,14,0)","v":0}]
[null,"Handicap allowance",null,{"$f":"VLOOKUP($E$5,'GA55'!C15:Y26,6,0)","v":0},null,null,{"$f":"'GA55'!Q12","v":"LIC"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,15,0)","v":100}]
[null,"BONUS",null,0,null,null,{"$f":"'GA55'!N12","v":"RPMF/RGHS"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,12,0)","v":658}]
[null,"Other",null,{"$f":"VLOOKUP($E$5,'GA55'!C17:Y28,6,0)","v":0},null,null,{"$f":"'GA55'!R12","v":"GIS"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,16,0)","v":0}]
[null,"Other",null,{"$f":"VLOOKUP($E$5,'GA55'!C18:Y29,7,0)","v":0},null,null,{"$f":"'GA55'!S12","v":"OTHER DED.1"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,17,0)","v":0}]
[null,null,null,null,null,null,{"$f":"'GA55'!T12","v":"OTHER DED.2"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,18,0)","v":0}]
[null,"TOTAL PAY",null,{"$f":"VLOOKUP(E5,'GA55'!C13:W24,9,0)","v":62348},null,null,{"$f":"'GA55'!U12","v":"Income tax"},null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$W$24,19,0)","v":0}]
[null,null,null,null,null,null,"TOTAL DED.:",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,20,0)","v":9758}]
[]
[null,null,null,"नियत वेतन"]
[null,null,null,"NET PAY",null,{"$f":"VLOOKUP($E$5,'GA55'!$C$13:$Y$24,21,0)","v":52590},null,"Rs."]
[null,"RUPEES IN WORDS ",null,{"$f":"PROPER(SpellNumber(F37))","v":"Fifty-Two Thousand Five Hundred Ninety"}]
[]
[]
[]
[]
[null,"Signature of Employee",null,null,null,null,"Signature of DDO"]
[null,{"$f":"'GA55'!D9","v":"VIJAY KUMAR PRAJAPAT"},null,null,null,null,{"$f":"'GA55'!F6","v":"श्री करमा राम"}]
[]
[null,"Print Date:",null,{"$f":"NOW()","v":"2022-11-26T23:00:32.170"}]