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

{"sheet":"Master Data","index":0,"n_rows":33,"n_cols":19,"rows_kept":33,"merged":[[1,1,1,4],[2,2,2,4],[9,5,10,5],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4]]}
[]
[null,"MASTER DATA",{"$nulls":15},"L-1","CDEO"]
[null,"कार्यालय का नाम ( पीईईओ या सीबीईओ )  : ","Mahatma Gandhi Government School (English Medium) Bar, (Beawar)",{"$nulls":14},"L-2","DEEO"]
[null,"कार्मिक का नाम  :","HEERALAL JAT","Designation /  पद :","Sr. Teacher",{"$nulls":12},"L-3","ADEO"]
[null,"Gazetted / Non-Gazetted : ","Non-Gazetted","Employee ID :","RJPA200312345678",{"$nulls":12},"L-4","ADPC"]
[null,"School/Office Name  :","MGGS BAR","DDO Name  :","Usha Paliya",{"$nulls":12},"L-5","APC"]
[null,"PAN No. :","ABCDE5555H","बैंक खाता संख्या :","51XXXXXXXXX96",{"$nulls":12},"L-6","CBEO"]
[null,"SI Number :","74XXX7","GPF / GPF - 2004  :","GPF",{"$nulls":12},"L-7","ACBEO-1"]
[null,"GPF Number :","74XXX8","PRAN No. / GPF-2004 Number :","71XXX10"]
[null,"SI Deducation Per Month  :",{"v":7000,"d":"7,000"},"जीपीएफ / जीपीएफ-2004  की मासिक कटौती :",7000,"परम पूज्य गुरुदेव वासुदेव जी महाराज ",{"$nulls":11},"L-8","ACBEO-2"]
[null,"01 March 2025 Basic Pay  (मूल वेतन) :",{"v":61300,"d":"61,300"},"Rate of HRA : ",{"v":10,"d":"10 %"},{"$nulls":12},"L-9","PEEO"]
[null," क्या आपने समर्पित वेतन उठाया है ?","YES","CCA लागु हो तो  Select Yes / No  :","NO",{"$nulls":12},"L-10","Principal"]
[null,"अगर आपने  Surrender उठाया है तो माह सलेक्ट करें :","SEP"," CCA लागू हो तो CITY सलेक्ट करे :",null,"youtube Video Link ",{"$nulls":11},"L-11","PEEO"]
[null,"आपको अभी कोनसा वेतन मिल रहा है :- ","Regular Pay","विकलांग भत्ता  : ",null,"https://youtu.be/ULIKPcv3e-U"]
[null,"Bonus :",{"v":6774,"d":"6,774"},"Income Tax Ded. @ Per Month :",2000,"https://youtu.be/GXryKE2B7fI"]
[null,"Group Insurance Rate @ :",null,"L.I.C. (Per Month) :",1103,"https://youtu.be/wU0JpB3heTQ"]
[null,"जिस माह से आयकर गणना प्रपत्र बनाना है ","2025-03-01","यदि वितीय वर्ष  2025-26 में मूल वेतन में परिवर्तन हुआ है तो लिखे :",null,"https://youtu.be/ULIKPcv3e-U"]
[null,"जिस माह तक आयकर गणना प्रपत्र बनाना है ","2026-02-01"," इन्क्रीमेंट के अतिरिक्त वेतन परिवर्तित होने पर माह सलेक्ट करे :",{"$nulls":13},"L-12","Principal"]
[{"$nulls":17},"L-13","Head Master"]
[null,"You Tube Video Link",null,"Present By :",{"$nulls":13},"L-14","Lecturer"]
[null,"https://youtu.be/wU0JpB3heTQ",null,"HEERALAL JAT  (Sr. Teacher)",null,"UPDATE ON",{"$nulls":11},"L-15","Sr. Teacher"]
[{"$nulls":3},"MGGS BAR (Beawar)",null,"2025-11-05",{"$nulls":11},"L-16","Teacher L-2"]
[{"$nulls":3},"V./P. - Chandawal Nagar, Sojat, Dist.- PALI",{"$nulls":13},"L-17","Teacher L-1"]
[{"$nulls":3},"heeralaljatchandawal@gmail.com",{"$nulls":13},"L-18","Prabodhak"]
[{"$nulls":17},"L-19","PTI - 1"]
[{"$nulls":17},"L-20","PTI - II"]
[{"$nulls":17},"L-21","PTI - III"]
[{"$nulls":17},"L-22","Librarian"]
[{"$nulls":17},"L-23","OA"]
[{"$nulls":17},"L-24","UDC"]
[{"$nulls":18},"LDC"]
[{"$nulls":18},"Lab Tec."]
[{"$nulls":18},"Peon"]

{"sheet":"Extra Ded. ","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"merged":[[0,0,0,2],[1,1,1,2],[2,2,2,10],[5,2,5,3],[5,5,23,5],[5,6,5,9],[5,11,23,11],[6,2,6,3],[6,6,6,9],[7,2,7,3],[7,6,7,9],[8,2,8,3],[8,6,8,9],[9,2,9,3],[9,6,9,9],[10,2,10,3],[10,6,10,9],[11,2,11,3],[11,6,11,9],[12,2,12,3],[12,6,12,9],[13,2,13,3],[13,6,13,9],[14,2,14,3],[14,6,14,9],[15,2,15,3],[15,6,15,9],[16,2,16,3],[16,6,16,9],[17,2,17,3],[17,6,17,9],[18,2,18,3],[18,6,18,9],[18,10,19,10],[19,2,19,3],[20,2,20,3],[20,6,20,9],[21,2,21,3],[21,6,21,9],[22,2,22,3],[22,6,22,9],[23,2,23,3],[23,6,23,9],[24,2,24,3],[24,6,24,9],[25,2,25,10]]}
["https://youtu.be/ULIKPcv3e-U"]
[null,"अधिक जानकारी के लिए ऊपर Youtube video का लिंक दिया गया है। "]
[null,null,"वेतन कटौती से अतिरिक्त कटौतिया जिसके तहत आप आयकर में छूट लेना चाहते है, तथा अतिरिक्त (अन्य) आय को यहाँ इन्द्राज करेंI"]
[]
[]
[null,null,"1. मकान किराया भत्ता (यदि रसीद के माध्यम से छूट लेनी हो तो राशि लिखे )",null,0,null,"20.  इक्विटी लिंक सेविंग स्कीम "]
[null,null,"2.  स्टैण्डर्ड डीडेक्सन (Standard Deduction)  75,000 (अधिकतम )",null,75000,null,"21.  गृह किराया धारा 10 (13-A) के अंतर्गत व धारा  10(14) के अंतर्गत  अन्य भत्ते जो कर मुक्त है "]
[null,null,"3. मनोरंजन भत्ता धारा  16  (ii) के अंतर्गत ",{"$nulls":3},"22. स्थगत वार्षिकी (Defferred Annuty)"]
[null,null,"4. व्यवसाय कर  धारा  16  (iii) के अंतर्गत  ",{"$nulls":3},"23. वेतन के अलावा जमा कराया गया आयकर  (TDS)"]
[null,null,"5. गृह सम्पति से प्राप्त किराया  - आय ",{"$nulls":3},"24.  अन्य व फिक्स डिपोजिट  (5 वर्ष हेतु )  (धारा 80 सी के अंतर्गत )"]
[null,null,"6. गृहकर ",{"$nulls":3},"25.   पारिवारिक पेंशन की मानक कटोती धारा 57 के अन्तगर्त ( अधिकतम सीमा रू 25000 )"]
[null,null,"7. गृह ऋण की मूल किस्त यहाँ लिखनी है, जो छूट लेनी हैI",{"$nulls":3},"26.  इन सभी के अतिरिक्त अन्य सभी प्रकार की कटोती जो धारा 80 सी के अंतर्गत आती है  (Other) "]
[null,null,"8. गृह ऋण की किस्त पर ब्याज जो छूट लेना है, यहाँ लिखें I",{"$nulls":3},"27.    म्यूच्यूअल फण्ड और अन्य कोई राशि  (जो धारा 80 सी के अंतर्गत छुट प्राप्त हो)"]
[null,null,"9. जीवन बीमा प्रीमियम  (जो वेतन से नहीं काटा गया है ) LIC",{"$nulls":3},"28.   धारा 80CCD(1B) - नवीन पेंशन योजना में अतिरिक्त अंशदान  (अधिकतम रुपये 50,000)"]
[null,null,"10. पी.एल.आई. (PLI)",{"$nulls":3},"29.   धारा 80 D चिकित्सा बीमा प्रीमियम "]
[null,null,"11. टियुशन फ़ीस (Tution Fees)",{"$nulls":3},"30.   धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार "]
[null,null,"12.  यू एल आई पी / वार्षिक प्लान",{"$nulls":3},"31.  धारा  80DDB विशिष्ट रोगों के उपचार हेतु छुट"]
[null,null,"13.  राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"32.   धारा  80E उच्च शिक्षा हेतु लिए गए ऋण का ब्याज "]
[null,null,"14.  राष्ट्रीय बचत पत्र पर अदत ब्याज ",{"$nulls":3},"33.  धारा 80G धर्मार्थ संस्थाओ आदि को दिए दान ( क श्रेणी में  100 प्रतिशत एव ख श्रेणी में 50 प्रतिशत)",{"$nulls":3},{"$f":"SUM(H20)+ ROUND(J20/2,0)","v":0}]
[null,null,"15.  लोक भविष्य निधि (PPF)",{"$nulls":3}," \"क\" श्रेणी में दान :-  ",null,"\"ख\" श्रेणी में दान :-   "]
[null,null,"16.  राष्ट्रीय बचत पत्र स्कीम (NSS) ",{"$nulls":3},"34.   धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में "]
[null,null,"17.  सुकन्या समृद्धि योजना में जमा राशि  (SSY)",{"$nulls":3},"35.   धारा 80 TTA बचत खाते पर अधिकतम ब्याज पर 10,000 तक छुट  194(IA) "]
[null,null,"18.   Bonds से ब्याज ",{"$nulls":3},"36.   धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान "]
[null,null,"19.   अन्य स्रोत से आय (शेयर मार्केट सहित सभी आय) :",{"$nulls":3},"37. राहत धारा  89 के तहत  (अगर छुट लेनी है तो राशि लिखे )",{"$nulls":3},0]
[null,null,"       US 80 EE & US 80EEA  & Others",{"$nulls":3},"38.  एफडी आदि अन्य जमा पर प्राप्त कुल ब्याज (पीपीएफ को छोड़कर)"]

{"sheet":"GA55","index":2,"n_rows":41,"n_cols":76,"rows_kept":41,"merged":[[0,1,0,27],[1,0,1,2],[1,3,1,7],[1,8,1,11],[1,12,1,15],[1,16,1,19],[1,20,1,26],[1,27,1,28],[2,0,2,1],[2,2,2,4],[2,6,2,8],[2,10,2,13],[2,14,2,16],[2,17,2,21],[2,22,2,25],[2,26,2,28],[3,0,3,12],[3,13,3,25],[3,26,4,26],[3,27,4,27],[3,28,4,28],[4,30,4,32],[5,30,5,32],[7,30,7,32],[28,2,28,7],[28,18,28,26],[29,2,29,7],[29,18,29,26]]}
[null,{"$f":"IF(AND('Master Data'!C3=\"\"),\"\",CONCATENATE(\"Office Name :- \",PROPER('Master Data'!C3)))","v":"Office Name :- Mahatma Gandhi Government School (English Medium) Bar, (Beawar)"}]
["Employee Name :-",null,null,{"$f":"UPPER(IF('Master Data'!C4=\"\",\"\",'Master Data'!C4))","v":"HEERALAL JAT"},{"$nulls":4},"Designation :-",{"$nulls":3},{"$f":"UPPER(IF('Master Data'!E4=\"\",\"\",'Master Data'!E4))","v":"SR. TEACHER"},{"$nulls":3},"Posting Place :-",{"$nulls":3},{"$f":"UPPER(IF('Master Data'!C6=\"\",\"\",'Master Data'!C6))","v":"MGGS BAR"},{"$nulls":6},"वेतन ड्रा मानचित्र "]
["PAN No. :-",null,{"$f":"UPPER(IF('Master Data'!C7=\"\",\"\",'Master Data'!C7))","v":"ABCDE5555H"},null,null,"SI No.",{"$f":"IF(AND('Master Data'!C8=\"\"),\"\",'Master Data'!C8)","v":"74XXX7"},null,null,"GPF",{"$f":"IF(AND('Master Data'!C9=\"\"),\"\",'Master Data'!C9)","v":"74XXX8"},{"$nulls":3},"PRAN No. :-",null,null,{"$f":"IF(AND('Master Data'!E9=\"\"),\"\",'Master Data'!E9)","v":"71XXX10"},{"$nulls":4},"Bank A/C.",{"$nulls":3},{"$f":"IF(AND('Master Data'!E7=\"\"),\"\",'Master Data'!E7)","v":"51XXXXXXXXX96"},{"$nulls":24},{"$f":"AZ15-ROUNDUP(ROUND((AZ15*3%)-(AZ15*3%)*2.9%,-2),0)","v":59500}]
["Pay received",{"$nulls":12},"Deducations",{"$nulls":12},"NET PAY","T.V. NO.","Enc.  DATE"]
["S.N.","Month","Basic With Grade Pay","DA","HRA","Wash All.","Handi. All.","CCA","Other-1","Other-2","Bonus","ROP","TOTAL","SI",{"$f":"IF('Master Data'!E8=\"\",\"\",'Master Data'!E8)","v":"GPF"},"L.I.C.","RGHS","SI Loan","GPF Loan","SI Int.","Other-1","HITKARI NIDHI","Other-2","Income Tax","Group Ins.","Total Ded.",{"$nulls":4},"https://youtu.be/GXryKE2B7fI",{"$nulls":7},{"$f":"'Master Data'!C12","v":"YES"},"GPF","Yes","Regular Pay","Under 60",null,1000]
[1,{"$f":"IFERROR(IF(BO12=\"\",\"\",BO12),\"\")","v":"2025-03-01"},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(B6=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B6,om,13,0),VLOOKUP(B6,om,4,0))))),\"\")","v":61300},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B6,om,7,0),\"\")))),\"\")","v":32489},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B6,om,8,0),\"\")))),\"\")","v":6130},0,{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F6,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},0,0,{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B6=\"Bonus\"),VLOOKUP(B6,om,4,0),\"\")))),\"\")","v":""},0,{"$f":"IF(B6=\"\",\"\",SUM(C6:L6))","v":99919},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B6,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B6,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B6,om,10,0),\"\")))),\"\")","v":875},0,0,0,0,{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B6=\"\"),\"\",IF(AND(C6=\"\"),\"\",IF(AND(B6=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B6=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},0,{"$f":"IFERROR(IF(B6=\"\",\"\",IF(AND(BQ12=\"\"),\"\",IF(OR(B6=$AX$24,B6=$AX$25,B6=$AX$26,B6=$AX$27,B6=$AX$28,B6=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B6,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B6=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C6=\"\"),\"\",IF(B6=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},{"$f":"IF(B6=\"\",\"\",SUM(N6:Y6))","v":17978},{"$f":"IFERROR(IF(AND(B6=\"\",M6=\"\",Z6=\"\"),\"\",SUM(M6-Z6)),\"\")","v":81941},{"$nulls":3},"Youtube Video Link For Your Help",{"$nulls":8},"GPF-2004","No","Fix Pay","Above 60",null,620]
[2,{"$f":"IFERROR(IF(BO13=\"\",\"\",BO13),\"\")","v":"2025-04-01"},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(B7=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B7,om,13,0),VLOOKUP(B7,om,4,0))))),\"\")","v":61300},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B7,om,7,0),\"\")))),\"\")","v":33715},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B7,om,8,0),\"\")))),\"\")","v":6130},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F7,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B7=\"Bonus\"),VLOOKUP(B7,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L6,\"\")))),\"\")","v":0},{"$f":"IF(B7=\"\",\"\",SUM(C7:L7))","v":101145},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B7,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B7,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B7,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B7=\"\"),\"\",IF(AND(C7=\"\"),\"\",IF(AND(B7=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B7=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W6,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(AND(BQ13=\"\"),\"\",IF(OR(B7=$AX$24,B7=$AX$25,B7=$AX$26,B7=$AX$27,B7=$AX$28,B7=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B7,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B7=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C7=\"\"),\"\",IF(B7=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":0},{"$f":"IF(B7=\"\",\"\",SUM(N7:Y7))","v":17978},{"$f":"IFERROR(IF(AND(B7=\"\",M7=\"\",Z7=\"\"),\"\",SUM(M7-Z7)),\"\")","v":83167},{"$nulls":15},"Above 80"]
[3,{"$f":"IFERROR(IF(BO14=\"\",\"\",BO14),\"\")","v":"2025-05-01"},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(B8=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B8,om,13,0),VLOOKUP(B8,om,4,0))))),\"\")","v":61300},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B8,om,7,0),\"\")))),\"\")","v":33715},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B8,om,8,0),\"\")))),\"\")","v":6130},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F8,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B8=\"Bonus\"),VLOOKUP(B8,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L7,\"\")))),\"\")","v":0},101145,{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B8,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B8,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B8,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B8=\"\"),\"\",IF(AND(C8=\"\"),\"\",IF(AND(B8=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B8=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W7,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B8=\"\",\"\",IF(AND(BQ14=\"\"),\"\",IF(OR(B8=$AX$24,B8=$AX$25,B8=$AX$26,B8=$AX$27,B8=$AX$28,B8=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B8,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B8=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C8=\"\"),\"\",IF(B8=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,83167,{"$nulls":3},"https://youtu.be/wU0JpB3heTQ",{"$nulls":12},"Jaipur (U.A.)","JAN","2025-03-01","L-1",null,null,"2024-03-01"]
[4,"2025-06-01",{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(B9=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B9,om,13,0),VLOOKUP(B9,om,4,0))))),\"\")","v":61300},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B9,om,7,0),\"\")))),\"\")","v":33715},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B9,om,8,0),\"\")))),\"\")","v":6130},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F9,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B9=\"Bonus\"),VLOOKUP(B9,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L8,\"\")))),\"\")","v":0},101145,{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B9,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B9,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B9,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B9=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(AND(B9=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B9=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W8,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B9=\"\",\"\",IF(AND(BQ15=\"\"),\"\",IF(OR(B9=$AX$24,B9=$AX$25,B9=$AX$26,B9=$AX$27,B9=$AX$28,B9=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B9,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B9=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(B9=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,83167,{"$nulls":16},"Ajmer","FEB","2025-04-01","L-2",{"$nulls":4},"2026-02-28",{"$nulls":4},{"$f":"IF('Master Data'!$E$11=9,10,20)","v":20}]
[5,"2025-07-01",{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(B10=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B10,om,13,0),VLOOKUP(B10,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B10,om,7,0),\"\")))),\"\")","v":34705},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B10,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F10,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B10=\"Bonus\"),VLOOKUP(B10,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L9,\"\")))),\"\")","v":0},104115,{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B10,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B10,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B10,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B10=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(B10=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B10=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W9,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B10=\"\",\"\",IF(AND(BQ16=\"\"),\"\",IF(OR(B10=$AX$24,B10=$AX$25,B10=$AX$26,B10=$AX$27,B10=$AX$28,B10=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B10,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B10=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(B10=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,86137,{"$nulls":16},"Bikaner","MAR","2025-05-01","L-3",null,"JAN","2025-01-01",null,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",'Master Data'!$C$11)","v":61300},{"$f":"IF(AND(AX10<$AZ$16),\"\",IF(AND(AX10>$AZ$17),\"\",BA10))","v":""},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(31%*BA10,0))","v":19003},{"$f":"IF(BB10=\"\",\"\",BC10)","v":""},{"$nulls":3},{"$f":"IFERROR(IF(OR('Master Data'!C14=$AP$6),\"\",'Master Data'!C10),\"\")","v":7000},null,{"$f":"BA10","v":61300},null,{"$f":"MONTH(AZ17)","v":2},{"$nulls":6},{"$f":"B6","v":"2025-03-01"}]
[6,"2025-08-01",{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(B11=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B11,om,13,0),VLOOKUP(B11,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B11,om,7,0),\"\")))),\"\")","v":34705},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B11,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F11,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B11=\"Bonus\"),VLOOKUP(B11,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L10,\"\")))),\"\")","v":0},104115,{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B11,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B11,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B11,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B11=\"\"),\"\",IF(AND(C11=\"\"),\"\",IF(AND(B11=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B11=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W10,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B11=\"\",\"\",IF(AND(BQ17=\"\"),\"\",IF(OR(B11=$AX$24,B11=$AX$25,B11=$AX$26,B11=$AX$27,B11=$AX$28,B11=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B11,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B11=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C11=\"\"),\"\",IF(B11=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,86137,{"$nulls":16},"Jodhpur","APR","2025-06-01","L-4",null,"FEB","2025-02-01",null,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",'Master Data'!$C$11)","v":61300},{"$f":"IF(AND(AX11<$AZ$16),\"\",IF(AND(AX11>$AZ$17),\"\",BA11))","v":""},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(31%*BA11,0))","v":19003},{"$f":"IF(BB11=\"\",\"\",BC11)","v":""},{"$nulls":3},{"$f":"IFERROR(IF(OR('Master Data'!C14=$AP$6),\"\",'Master Data'!C10),\"\")","v":7000},null,{"$f":"BA11","v":61300}]
[7,"2025-09-01",{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(B12=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B12,om,13,0),VLOOKUP(B12,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B12,om,7,0),\"\")))),\"\")","v":34705},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B12,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F12,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B12=\"Bonus\"),VLOOKUP(B12,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L11,\"\")))),\"\")","v":0},104115,{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B12,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B12,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B12,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B12=\"\"),\"\",IF(AND(C12=\"\"),\"\",IF(AND(B12=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B12=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W11,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B12=\"\",\"\",IF(AND(BQ18=\"\"),\"\",IF(OR(B12=$AX$24,B12=$AX$25,B12=$AX$26,B12=$AX$27,B12=$AX$28,B12=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B12,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B12=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C12=\"\"),\"\",IF(B12=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,86137,{"$nulls":16},"Kota","MAY","2025-07-01","L-5",null,"MAR","2025-03-01",3,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU12))","v":61300},{"$f":"IF(AND(AX12<$AZ$16),\"\",IF(AND(AX12>$AZ$17),\"\",BA12))","v":61300},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(53%*BA12,0))","v":32489},{"$f":"IF(BB12=\"\",\"\",BC12)","v":32489},{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB12,0)),\"\")","v":6130},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB12<18001,135,IF(BB12<33501,220,IF(BB12<54001,330,440))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB12<18001,265,IF(BB12<33501,440,IF(BB12<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF('Master Data'!$E$8=\"GPF-2004\",\"\",IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$E$10)),\"\")","v":7000},{"$f":"BA12","v":61300},"2025-03-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(AZ16),MONTH(AZ16),DAY(AZ16))))),\"\")","v":"2025-03-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(AZ16),MONTH(AZ16),DAY(AZ16))))),\"\")","v":"2025-03-01"},{"$f":"IF(AND(BM12=\"\"),\"\",IF(AND(BM12=$BK$12),$BK$12,IF(AND(BM12=$BK$13),$BK$13,IF(AND(BM12=$BK$14),$BK$14,IF(AND(BM12=$BK$15),$BK$15,IF(AND(BM12=$BK$16),$BK$16,IF(AND(BM12=$BK$17),$BK$17,IF(AND(BM12=$BK$18),$BK$18,IF(AND(BM12=$BK$19),$BK$19,IF(AND(BM12=$BK$20),$BK$20,IF(AND(BM12=$BK$21),$BK$21,IF(AND(BM12=$BK$22),$BK$22,IF(AND(BM12=$BK$23),$BK$23,IF(AND(BM12=$BK$24),$BM$24,IF(AND(BM12=$BK$25),$BM$25,IF(AND(BM12=$BK$26),$BM$26,IF(AND(BM12=$BK$27),$BM$27,IF(AND(BM12=$BK$28),$BM$28,IF(AND(BM12=$BK$29),$BM$29,IF(AND(BM12=$BK$30),$BM$30,IF(AND(BM12=$BK$31),$BM$31,IF(AND(BM12=$BK$32),$BM$32,\"\"))))))))))))))))))))))","v":"2025-03-01"},{"$f":"IFERROR(IF(BM12=\"\",\"\",IF(AND(BL12=$BK$24),$BM$24,IF(AND(BL12=$BK$25),$BM$25,IF(AND(BL12=$BK$26),$BM$26,IF(AND(BL12=$BK$27),$BM$27,IF(AND(BL12=$BK$28),$BM$28,IF(AND(BL12=$BK$29),$BM$29,IF(AND(BL12=$BK$30),$BM$30,IF(AND(BL12=$BK$31),$BM$31,IF(AND(BL12=$BK$32),$BM$32,BN12)))))))))),\"\")","v":"2025-03-01"},null,{"$f":"IFERROR(IF(BM12=\"\",\"\",IF(B6=$AX$24,$AX$24,IF(B6=$AX$25,$AX$25,IF(B6=$AX$26,$AX$26,IF(B6=$AX$27,$AX$27,IF(B6=$AX$28,$AX$28,IF(B6=$AX$29,$AX$29,IF(BM12>$AZ$17,\"\",BM12)))))))),\"\")","v":"2025-03-01"},{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX12),'Master Data'!$E$17,'Master Data'!$C$11))","v":61300},null,null,{"$f":"IF(B6=\"\",\"\",X6)","v":2000}]
[8,"2025-10-01",{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(B13=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B13,om,13,0),VLOOKUP(B13,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B13,om,7,0),\"\")))),\"\")","v":36598},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B13,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F13,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B13=\"Bonus\"),VLOOKUP(B13,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L12,\"\")))),\"\")","v":0},106008,{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B13,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B13,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B13,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B13=\"\"),\"\",IF(AND(C13=\"\"),\"\",IF(AND(B13=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B13=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W12,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B13=\"\",\"\",IF(AND(BQ19=\"\"),\"\",IF(OR(B13=$AX$24,B13=$AX$25,B13=$AX$26,B13=$AX$27,B13=$AX$28,B13=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B13,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B13=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C13=\"\"),\"\",IF(B13=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,88030,{"$nulls":17},"JUN","2025-08-01","L-6",null,"APR","2025-04-01",4,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU13))","v":61300},{"$f":"IF(AND(AX13<$AZ$16),\"\",IF(AND(AX13>$AZ$17),\"\",BA13))","v":61300},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(55%*BA13,0))","v":33715},{"$f":"IF(BB13=\"\",\"\",BC13)","v":33715},{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB13,0)),\"\")","v":6130},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB13<18001,265,IF(BB13<33501,440,IF(BB13<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB13<18001,265,IF(BB13<33501,440,IF(BB13<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF('Master Data'!$E$8=\"GPF-2004\",\"\",IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$E$10)),\"\")","v":7000},{"$f":"BA13","v":61300},"2025-04-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL12),MONTH(BL12)+1,DAY(BL12))))),\"\")","v":"2025-04-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM12),MONTH(BM12)+1,DAY(BM12))))),\"\")","v":"2025-04-01"},{"$f":"IF(AND(BM13=\"\"),\"\",IF(AND(BM13=$BK$12),$BK$12,IF(AND(BM13=$BK$13),$BK$13,IF(AND(BM13=$BK$14),$BK$14,IF(AND(BM13=$BK$15),$BK$15,IF(AND(BM13=$BK$16),$BK$16,IF(AND(BM13=$BK$17),$BK$17,IF(AND(BM13=$BK$18),$BK$18,IF(AND(BM13=$BK$19),$BK$19,IF(AND(BM13=$BK$20),$BK$20,IF(AND(BM13=$BK$21),$BK$21,IF(AND(BM13=$BK$22),$BK$22,IF(AND(BM13=$BK$23),$BK$23,IF(AND(BM13=$BK$24),$BM$24,IF(AND(BM13=$BK$25),$BM$25,IF(AND(BM13=$BK$26),$BM$26,IF(AND(BM13=$BK$27),$BM$27,IF(AND(BM13=$BK$28),$BM$28,IF(AND(BM13=$BK$29),$BM$29,IF(AND(BM13=$BK$30),$BM$30,IF(AND(BM13=$BK$31),$BM$31,IF(AND(BM13=$BK$32),$BM$32,\"\"))))))))))))))))))))))","v":"2025-04-01"},{"$f":"IFERROR(IF(BM13=\"\",\"\",IF(AND(BL13=$BK$24),$BM$24,IF(AND(BL13=$BK$25),$BM$25,IF(AND(BL13=$BK$26),$BM$26,IF(AND(BL13=$BK$27),$BM$27,IF(AND(BL13=$BK$28),$BM$28,IF(AND(BL13=$BK$29),$BM$29,IF(AND(BL13=$BK$30),$BM$30,IF(AND(BL13=$BK$31),$BM$31,IF(AND(BL13=$BK$32),$BM$32,BN13)))))))))),\"\")","v":"2025-04-01"},null,{"$f":"IFERROR(IF(BM13=\"\",\"\",IF(B7=$AX$24,$AX$24,IF(B7=$AX$25,$AX$25,IF(B7=$AX$26,$AX$26,IF(B7=$AX$27,$AX$27,IF(B7=$AX$28,$AX$28,IF(B7=$AX$29,$AX$29,IF(BM13>$AZ$17,\"\",BM13)))))))),\"\")","v":"2025-04-01"},{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX13),'Master Data'!$E$17,BU12))","v":61300},null,null,{"$f":"IF(B7=\"\",\"\",X7)","v":2000}]
[9,"2025-11-01",{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(B14=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B14,om,13,0),VLOOKUP(B14,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B14,om,7,0),\"\")))),\"\")","v":36598},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B14,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F14,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B14=\"Bonus\"),VLOOKUP(B14,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L13,\"\")))),\"\")","v":0},106008,{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B14,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B14,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B14,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B14=\"\"),\"\",IF(AND(C14=\"\"),\"\",IF(AND(B14=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B14=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W13,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B14=\"\",\"\",IF(AND(BQ20=\"\"),\"\",IF(OR(B14=$AX$24,B14=$AX$25,B14=$AX$26,B14=$AX$27,B14=$AX$28,B14=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B14,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B14=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C14=\"\"),\"\",IF(B14=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,88030,{"$nulls":17},"JUL","2025-09-01","L-7",null,"MAY","2025-05-01",5,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU14))","v":61300},{"$f":"IF(AND(AX14<$AZ$16),\"\",IF(AND(AX14>$AZ$17),\"\",BA14))","v":61300},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(55%*BA14,0))","v":33715},{"$f":"IF(BB14=\"\",\"\",BC14)","v":33715},{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB14,0)),\"\")","v":6130},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB14<18001,265,IF(BB14<33501,440,IF(BB14<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB14<18001,265,IF(BB14<33501,440,IF(BB14<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB14<23101,1450,IF(BB14<28501,1625,IF(BB14<38501,2100,IF(BB14<51501,2850,IF(BB14<62001,3575,IF(BB14<72001,4200,IF(BB14<80001,4800,IF(BB14<116001,6150,IF(BB14<167001,8900,10500)))))))))*2,'Master Data'!$E$10)),\"\")","v":7000},{"$f":"BA14","v":61300},"2025-05-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL13),MONTH(BL13)+1,DAY(BL13))))),\"\")","v":"2025-05-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM13),MONTH(BM13)+1,DAY(BM13))))),\"\")","v":"2025-05-01"},"2025-05-01","2025-05-01",null,{"$f":"IFERROR(IF(BM14=\"\",\"\",IF(B8=$AX$24,$AX$24,IF(B8=$AX$25,$AX$25,IF(B8=$AX$26,$AX$26,IF(B8=$AX$27,$AX$27,IF(B8=$AX$28,$AX$28,IF(B8=$AX$29,$AX$29,IF(BM14>$AZ$17,\"\",BM14)))))))),\"\")","v":"2025-05-01"},{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX14),'Master Data'!$E$17,BU13))","v":61300},null,null,2000]
[10,"2025-12-01",{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(B15=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B15,om,13,0),VLOOKUP(B15,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B15,om,7,0),\"\")))),\"\")","v":36598},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B15,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F15,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B15=\"Bonus\"),VLOOKUP(B15,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L14,\"\")))),\"\")","v":0},106008,{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B15,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B15,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B15,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B15=\"\"),\"\",IF(AND(C15=\"\"),\"\",IF(AND(B15=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B15=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":250},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W14,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B15=\"\",\"\",IF(AND(BQ21=\"\"),\"\",IF(OR(B15=$AX$24,B15=$AX$25,B15=$AX$26,B15=$AX$27,B15=$AX$28,B15=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B15,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B15=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C15=\"\"),\"\",IF(B15=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},18228,87780,{"$nulls":17},"AUG","2025-10-01","L-8",null,"JUN","2025-06-01",6,{"$f":"IF(AND('Master Data'!C11=\"\"),\"\",'Master Data'!C11)","v":61300},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU15))","v":61300},61300,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(55%*BA15,0))","v":33715},{"$f":"IF(BB15=\"\",\"\",BC15)","v":33715},{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB15,0)),\"\")","v":6130},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB15<18001,265,IF(BB15<33501,440,IF(BB15<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB15<18001,265,IF(BB15<33501,440,IF(BB15<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB15<23101,1450,IF(BB15<28501,1625,IF(BB15<38501,2100,IF(BB15<51501,2850,IF(BB15<62001,3575,IF(BB15<72001,4200,IF(BB15<80001,4800,IF(BB15<116001,6150,IF(BB15<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},61300,"2025-06-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL14),MONTH(BL14)+1,DAY(BL14))))),\"\")","v":"2025-06-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM14),MONTH(BM14)+1,DAY(BM14))))),\"\")","v":"2025-06-01"},"2025-06-01","2025-06-01",null,"2025-06-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX15),'Master Data'!$E$17,BU14))","v":61300},null,null,2000]
[11,"2026-01-01",{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(B16=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B16,om,13,0),VLOOKUP(B16,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B16,om,7,0),\"\")))),\"\")","v":36598},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B16,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F16,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B16=\"Bonus\"),VLOOKUP(B16,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L15,\"\")))),\"\")","v":0},106008,{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B16,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B16,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B16,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B16=\"\"),\"\",IF(AND(C16=\"\"),\"\",IF(AND(B16=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B16=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W15,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B16=\"\",\"\",IF(AND(BQ22=\"\"),\"\",IF(OR(B16=$AX$24,B16=$AX$25,B16=$AX$26,B16=$AX$27,B16=$AX$28,B16=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B16,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B16=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C16=\"\"),\"\",IF(B16=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,88030,{"$nulls":17},"SEP","2025-11-01","L-9",null,"JUL","2025-07-01",7,{"$f":"IF(AND('Master Data'!C17=\"\"),\"\",'Master Data'!C17)","v":"2025-03-01"},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU16))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(55%*BA16,0))","v":34705},34705,{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB16,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB16<18001,265,IF(BB16<33501,440,IF(BB16<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB16<18001,265,IF(BB16<33501,440,IF(BB16<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB16<23101,1450,IF(BB16<28501,1625,IF(BB16<38501,2100,IF(BB16<51501,2850,IF(BB16<62001,3575,IF(BB16<72001,4200,IF(BB16<80001,4800,IF(BB16<116001,6150,IF(BB16<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},{"$f":"BA16","v":63100},"2025-07-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL15),MONTH(BL15)+1,DAY(BL15))))),\"\")","v":"2025-07-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM15),MONTH(BM15)+1,DAY(BM15))))),\"\")","v":"2025-07-01"},"2025-07-01","2025-07-01",null,"2025-07-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18='GA55'!AX16),'Master Data'!E17,MROUND(BU15*1.03,100)))","v":63100},null,null,2000]
[12,"2026-02-01",{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(B17=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B17,om,13,0),VLOOKUP(B17,om,4,0))))),\"\")","v":63100},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B17,om,7,0),\"\")))),\"\")","v":36598},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B17,om,8,0),\"\")))),\"\")","v":6310},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F17,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B17=\"Bonus\"),VLOOKUP(B17,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L16,\"\")))),\"\")","v":0},106008,{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B17,om,11,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B17,om,12,0),\"\")))),\"\")","v":7000},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":1103},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B17,om,10,0),\"\")))),\"\")","v":875},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B17=\"\"),\"\",IF(AND(C17=\"\"),\"\",IF(AND(B17=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B17=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W16,\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B17=\"\",\"\",IF(AND(BQ23=\"\"),\"\",IF(OR(B17=$AX$24,B17=$AX$25,B17=$AX$26,B17=$AX$27,B17=$AX$28,B17=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B17,om,9,0),\"\")))),\"\")","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B17=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C17=\"\"),\"\",IF(B17=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},17978,88030,{"$nulls":17},"OCT","2025-12-01","L-10",null,"AUG","2025-08-01",8,{"$f":"IF(AND('Master Data'!C18=\"\"),\"\",'Master Data'!C18)","v":"2026-02-01"},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU17))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(55%*BA17,0))","v":34705},34705,{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB17,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB17<18001,265,IF(BB17<33501,440,IF(BB17<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB17<18001,265,IF(BB17<33501,440,IF(BB17<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB17<23101,1450,IF(BB17<28501,1625,IF(BB17<38501,2100,IF(BB17<51501,2850,IF(BB17<62001,3575,IF(BB17<72001,4200,IF(BB17<80001,4800,IF(BB17<116001,6150,IF(BB17<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},{"$f":"BJ16","v":63100},"2025-08-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL16),MONTH(BL16)+1,DAY(BL16))))),\"\")","v":"2025-08-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM16),MONTH(BM16)+1,DAY(BM16))))),\"\")","v":"2025-08-01"},"2025-08-01","2025-08-01",null,"2025-08-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX17),'Master Data'!$E$17,BU16))","v":63100},null,null,2000]
[13,"Bonus",{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(B18=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B18,om,13,0),VLOOKUP(B18,om,4,0))))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B18,om,7,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B18,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F18,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B18=\"Bonus\"),VLOOKUP(B18,om,4,0),\"\")))),\"\")","v":6774},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L17,\"\")))),\"\")","v":""},6774,{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B18,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B18,om,12,0),\"\")))),\"\")","v":1694},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B18,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B18=\"\"),\"\",IF(AND(C18=\"\"),\"\",IF(AND(B18=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B18=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W17,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B18=\"\",\"\",IF(AND(BQ24=\"\"),\"\",IF(OR(B18=$AX$24,B18=$AX$25,B18=$AX$26,B18=$AX$27,B18=$AX$28,B18=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B18,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B18=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C18=\"\"),\"\",IF(B18=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},1694,5080,{"$nulls":17},"NOV","2026-01-01","L-11",null,"SEP","2025-09-01",9,{"$f":"IF(AND('Master Data'!C11=\"\"),\"\",MROUND(AZ15*1.03,100))","v":63100},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU18))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(55%*BA18,0))","v":34705},34705,{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB18,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB18<18001,265,IF(BB18<33501,440,IF(BB18<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB18<18001,265,IF(BB18<33501,440,IF(BB18<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB18<23101,1450,IF(BB18<28501,1625,IF(BB18<38501,2100,IF(BB18<51501,2850,IF(BB18<62001,3575,IF(BB18<72001,4200,IF(BB18<80001,4800,IF(BB18<116001,6150,IF(BB18<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},{"$f":"BJ17","v":63100},"2025-09-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL17),MONTH(BL17)+1,DAY(BL17))))),\"\")","v":"2025-09-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM17),MONTH(BM17)+1,DAY(BM17))))),\"\")","v":"2025-09-01"},"2025-09-01","2025-09-01",null,"2025-09-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX18),'Master Data'!$E$17,BU17))","v":63100},null,null,2000]
[14,"PL Surrender",{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(B19=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B19,om,13,0),VLOOKUP(B19,om,4,0))))),\"\")","v":31550},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B19,om,7,0),\"\")))),\"\")","v":17353},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B19,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F19,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B19=\"Bonus\"),VLOOKUP(B19,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L18,\"\")))),\"\")","v":""},48903,{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B19,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B19,om,12,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B19,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B19=\"\"),\"\",IF(AND(C19=\"\"),\"\",IF(AND(B19=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B19=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W18,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(AND(BQ25=\"\"),\"\",IF(OR(B19=$AX$24,B19=$AX$25,B19=$AX$26,B19=$AX$27,B19=$AX$28,B19=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B19,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B19=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C19=\"\"),\"\",IF(B19=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},0,48903,{"$nulls":17},"DEC","2026-02-01","L-12",null,"OCT","2025-10-01",10,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU19))","v":63100},{"$f":"IF(AND(AX19<$AZ$16),\"\",IF(AND(AX19>$AZ$17),\"\",BA19))","v":63100},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(58%*BA19,0))","v":36598},{"$f":"IF(BB19=\"\",\"\",BC19)","v":36598},{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB19,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB19<18001,265,IF(BB19<33501,440,IF(BB19<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB19<18001,265,IF(BB19<33501,440,IF(BB19<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB19<23101,1450,IF(BB19<28501,1625,IF(BB19<38501,2100,IF(BB19<51501,2850,IF(BB19<62001,3575,IF(BB19<72001,4200,IF(BB19<80001,4800,IF(BB19<116001,6150,IF(BB19<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},63100,"2025-10-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL18),MONTH(BL18)+1,DAY(BL18))))),\"\")","v":"2025-10-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM18),MONTH(BM18)+1,DAY(BM18))))),\"\")","v":"2025-10-01"},"2025-10-01","2025-10-01",null,"2025-10-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX19),'Master Data'!$E$17,BU18))","v":63100},null,null,2000]
[15,"DA Arrear 53% to 55%",{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(B20=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B20,om,13,0),VLOOKUP(B20,om,4,0))))),\"\")","v":0},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B20,om,7,0),\"\")))),\"\")","v":3678},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B20,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F20,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B20=\"Bonus\"),VLOOKUP(B20,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L19,\"\")))),\"\")","v":""},3678,{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B20,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B20,om,12,0),\"\")))),\"\")","v":3678},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B20,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B20=\"\"),\"\",IF(AND(C20=\"\"),\"\",IF(AND(B20=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B20=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W19,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B20=\"\",\"\",IF(AND(BQ26=\"\"),\"\",IF(OR(B20=$AX$24,B20=$AX$25,B20=$AX$26,B20=$AX$27,B20=$AX$28,B20=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B20,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B20=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C20=\"\"),\"\",IF(B20=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},3678,0,{"$nulls":19},"L-13",null,"NOV","2025-11-01",11,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU20))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(58%*BA20,0))","v":36598},36598,{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB20,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB20<18001,265,IF(BB20<33501,440,IF(BB20<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB20<18001,265,IF(BB20<33501,440,IF(BB20<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB20<23101,1450,IF(BB20<28501,1625,IF(BB20<38501,2100,IF(BB20<51501,2850,IF(BB20<62001,3575,IF(BB20<72001,4200,IF(BB20<80001,4800,IF(BB20<116001,6150,IF(BB20<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},63100,"2025-11-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL19),MONTH(BL19)+1,DAY(BL19))))),\"\")","v":"2025-11-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM19),MONTH(BM19)+1,DAY(BM19))))),\"\")","v":"2025-11-01"},"2025-11-01","2025-11-01",null,"2025-11-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX20),'Master Data'!$E$17,BU19))","v":63100},null,null,2000]
[16,"DA Arrear 55% to 58%",{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(B21=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B21,om,13,0),VLOOKUP(B21,om,4,0))))),\"\")","v":0},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B21,om,7,0),\"\")))),\"\")","v":5679},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B21,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F21,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B21=\"Bonus\"),VLOOKUP(B21,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L20,\"\")))),\"\")","v":""},5679,{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B21,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B21,om,12,0),\"\")))),\"\")","v":5679},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B21,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B21=\"\"),\"\",IF(AND(C21=\"\"),\"\",IF(AND(B21=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B21=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W20,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B21=\"\",\"\",IF(AND(BQ27=\"\"),\"\",IF(OR(B21=$AX$24,B21=$AX$25,B21=$AX$26,B21=$AX$27,B21=$AX$28,B21=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B21,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B21=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C21=\"\"),\"\",IF(B21=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},5679,0,{"$nulls":19},"L-14",null,"DEC","2025-12-01",12,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU21))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(58%*BA21,0))","v":36598},36598,{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB21,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB21<18001,265,IF(BB21<33501,440,IF(BB21<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB21<18001,265,IF(BB21<33501,440,IF(BB21<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB21<23101,1450,IF(BB21<28501,1625,IF(BB21<38501,2100,IF(BB21<51501,2850,IF(BB21<62001,3575,IF(BB21<72001,4200,IF(BB21<80001,4800,IF(BB21<116001,6150,IF(BB21<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},63100,"2025-12-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL20),MONTH(BL20)+1,DAY(BL20))))),\"\")","v":"2025-12-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM20),MONTH(BM20)+1,DAY(BM20))))),\"\")","v":"2025-12-01"},"2025-12-01","2025-12-01",null,"2025-12-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX21),'Master Data'!$E$17,BU20))","v":63100},null,null,2000]
[17,"Fixation arear",{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(B22=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B22,om,13,0),VLOOKUP(B22,om,4,0))))),\"\")","v":0},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B22,om,7,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B22,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F22,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B22=\"Bonus\"),VLOOKUP(B22,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L21,\"\")))),\"\")","v":""},0,{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B22,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B22,om,12,0),\"\")))),\"\")","v":0},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B22,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B22=\"\"),\"\",IF(AND(C22=\"\"),\"\",IF(AND(B22=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B22=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W21,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B22=\"\",\"\",IF(AND(BQ28=\"\"),\"\",IF(OR(B22=$AX$24,B22=$AX$25,B22=$AX$26,B22=$AX$27,B22=$AX$28,B22=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B22,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B22=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C22=\"\"),\"\",IF(B22=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},0,0,{"$nulls":19},"L-15",null,"JAN","2026-01-01",1,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU22))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(58%*BA22,0))","v":36598},36598,{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB22,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB22<18001,265,IF(BB22<33501,440,IF(BB22<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB22<18001,265,IF(BB22<33501,440,IF(BB22<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB22<23101,1450,IF(BB22<28501,1625,IF(BB22<38501,2100,IF(BB22<51501,2850,IF(BB22<62001,3575,IF(BB22<72001,4200,IF(BB22<80001,4800,IF(BB22<116001,6150,IF(BB22<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},63100,"2026-01-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL21),MONTH(BL21)+1,DAY(BL21))))),\"\")","v":"2026-01-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM21),MONTH(BM21)+1,DAY(BM21))))),\"\")","v":"2026-01-01"},"2026-01-01","2026-01-01",null,"2026-01-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX22),'Master Data'!$E$17,BU21))","v":63100},null,null,2000]
[18,"PL Surrender Arrear",{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(B23=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B23,om,13,0),VLOOKUP(B23,om,4,0))))),\"\")","v":0},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B23,om,7,0),\"\")))),\"\")","v":947},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B23,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F23,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B23=\"Bonus\"),VLOOKUP(B23,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L22,\"\")))),\"\")","v":""},947,{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B23,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B23,om,12,0),\"\")))),\"\")","v":947},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B23,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B23=\"\"),\"\",IF(AND(C23=\"\"),\"\",IF(AND(B23=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B23=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W22,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B23=\"\",\"\",IF(AND(BQ29=\"\"),\"\",IF(OR(B23=$AX$24,B23=$AX$25,B23=$AX$26,B23=$AX$27,B23=$AX$28,B23=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B23,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B23=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C23=\"\"),\"\",IF(B23=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},947,0,{"$nulls":19},"L-16",null,"FEB","2026-02-01",2,null,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$C$14=$AP$6),$AZ$15,BU23))","v":63100},63100,{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND(58%*BA23,0))","v":36598},{"$f":"IF(BB23=\"\",\"\",BC23)","v":36598},{"$f":"IFERROR(IF(AND('Master Data'!$C$11=\"\"),\"\",ROUND('Master Data'!$E$11%*BB23,0)),\"\")","v":6310},{"$f":"'Master Data'!$E$15","v":2000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB23<18001,265,IF(BB23<33501,440,IF(BB23<54001,658,875))),IF(AND('Master Data'!$E$8=\"GPF\"),IF(BB23<18001,265,IF(BB23<33501,440,IF(BB23<54001,658,875))),\"\"))),\"\")","v":875},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",'Master Data'!$C$10),\"\")","v":7000},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6),\"\",IF('Master Data'!$E$8=\"GPF-2004\",IF(BB23<23101,1450,IF(BB23<28501,1625,IF(BB23<38501,2100,IF(BB23<51501,2850,IF(BB23<62001,3575,IF(BB23<72001,4200,IF(BB23<80001,4800,IF(BB23<116001,6150,IF(BB23<167001,8900,10500))))))))),'Master Data'!$E$10)),\"\")","v":7000},63100,"2026-02-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL22),MONTH(BL22)+1,DAY(BL22))))),\"\")","v":"2026-02-01"},{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BM22),MONTH(BM22)+1,DAY(BM22))))),\"\")","v":"2026-02-01"},"2026-02-01","2026-02-01",null,"2026-02-01",{"$nulls":3},{"$f":"IF(AND('Master Data'!$C$11=\"\"),\"\",IF(AND('Master Data'!$E$18=AX23),'Master Data'!$E$17,BU22))","v":63100},null,null,2000]
[19,"ACP/MACP Arrear",{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(B24=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B24,om,13,0),VLOOKUP(B24,om,4,0))))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B24,om,7,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B24,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F24,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B24=\"Bonus\"),VLOOKUP(B24,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L23,\"\")))),\"\")","v":""},0,{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B24,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B24,om,12,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B24,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B24=\"\"),\"\",IF(AND(C24=\"\"),\"\",IF(AND(B24=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B24=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W23,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",\"\",IF(AND(BQ30=\"\"),\"\",IF(OR(B24=$AX$24,B24=$AX$25,B24=$AX$26,B24=$AX$27,B24=$AX$28,B24=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B24,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B24=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C24=\"\"),\"\",IF(B24=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},0,0,{"$nulls":19},"L-17",null,null,{"$f":"BM24","v":"Bonus"},null,null,{"$f":"'Master Data'!C15","v":{"v":6774,"d":"6,774"}},null,null,{"$f":"IF(BC24=\"\",\"\",BC24)","v":""},{"$nulls":4},{"$f":"IF(AND('Master Data'!C14=$AP$6),\"\",ROUND(BA24*25%,0))","v":1694},null,"2026-03-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL23),MONTH(BL23)+1,DAY(BL23))))),\"\")","v":"2026-03-01"},"Bonus","","Bonus",null,{"$f":"IFERROR(IF(BM24=\"\",\"\",IF(B18=$AX$24,$AX$24,IF(B18=$AX$25,$AX$25,IF(B18=$AX$26,$AX$26,IF(B18=$AX$27,$AX$27,IF(B18=$AX$28,$AX$28,IF(B18=$AX$29,$AX$29,IF(BM24>$AZ$17,\"\",BM24)))))))),\"\")","v":"Bonus"},{"$nulls":6},""]
[20,"",{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(B25=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B25,om,13,0),VLOOKUP(B25,om,4,0))))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B25,om,7,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B25,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F25,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B25=\"Bonus\"),VLOOKUP(B25,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L24,\"\")))),\"\")","v":""},"",{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B25,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B25,om,12,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B25,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B25=\"\"),\"\",IF(AND(C25=\"\"),\"\",IF(AND(B25=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B25=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W24,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B25=\"\",\"\",IF(AND(BQ31=\"\"),\"\",IF(OR(B25=$AX$24,B25=$AX$25,B25=$AX$26,B25=$AX$27,B25=$AX$28,B25=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B25,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B25=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C25=\"\"),\"\",IF(B25=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},"","",{"$nulls":19},"L-18",null,null,{"$f":"BM25","v":"PL Surrender"},null,null,{"$f":"IF('GA55'!C13='GA55'!AP6,\"\",IF(OR('Master Data'!C12=\"NO\",'Master Data'!C13=\"\"),\"\",VLOOKUP('Master Data'!C13,AW12:BD29,5,0)/2))","v":31550},null,{"$f":"IF('Master Data'!$C$14=$AP$6,\"\",IF(AND(BA25=\"\"),\"\",IF(OR('Master Data'!C13=AW12),ROUND(53%*BA25,0),IF(OR('Master Data'!C13=AW13,'Master Data'!C13=AW14,'Master Data'!C13=AW15,'Master Data'!C13=AW16,'Master Data'!C13=AW17,'Master Data'!C13=AW18,'Master Data'!C13=AW18),ROUND(55%*BA25,0),ROUND(58%*BA25,0)))))","v":17353},{"$f":"IF(BC25=\"\",\"\",BC25)","v":17353},{"$nulls":6},"2026-04-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL24),MONTH(BL24)+1,DAY(BL24))))),\"\")","v":"2026-04-01"},"PL Surrender","","PL Surrender",null,"PL Surrender",{"$nulls":6},""]
[21,"",{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(B26=$AX$24,\"\",IF(AND('Master Data'!$C$14=$AP$6),VLOOKUP(B26,om,13,0),VLOOKUP(B26,om,4,0))))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B26,om,7,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B26,om,8,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),G25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ33=\"\"),\"\",IF('Master Data'!$E$12=\"NO\",\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),F26,IF(AND('Master Data'!$E$13=$AR$9),$AS$6,IF(AND('Master Data'!$E$13=$AR$10),$AS$6,IF(AND('Master Data'!$E$13=$AR$11),$AS$6,IF(AND('Master Data'!$E$13=$AR$12),$AS$6,$AS$5))))))))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),I25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),J25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND('Master Data'!$C$14=$AP$6),\"\",IF(AND('Master Data'!$C$15<>0),IF(AND(B26=\"Bonus\"),VLOOKUP(B26,om,4,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),L25,\"\")))),\"\")","v":""},"",{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B26,om,11,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$25),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B26,om,12,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),'Master Data'!$E$16,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B26,om,10,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),R25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),S25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),T25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),U25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B26=\"\"),\"\",IF(AND(C26=\"\"),\"\",IF(AND(B26=$AT$17,'Master Data'!$C$5=\"Gazetted\"),500,IF(AND(B26=$AT$17,'Master Data'!$C$5=\"Non-Gazetted\"),250,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),W25,\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(B26=\"\",\"\",IF(AND(BQ32=\"\"),\"\",IF(OR(B26=$AX$24,B26=$AX$25,B26=$AX$26,B26=$AX$27,B26=$AX$28,B26=$AX$29),\"\",IF(AND('Master Data'!$C$14=$AP$5),VLOOKUP(B26,om,9,0),\"\")))),\"\")","v":""},{"$f":"IFERROR(IF(OR('Master Data'!$C$14=$AP$6,B26=\"\",'Master Data'!$C$11=\"\"),\"\",IF(AND(C26=\"\"),\"\",IF(B26=$AT$9,'Master Data'!$C$16,\"\"))),\"\")","v":""},"","",{"$nulls":19},"L-19",null,null,"DA Arrear 53% to 55%",{"$nulls":4},{"$f":"(ROUND((BA12*55%),0)-ROUND((BA12*53%),0))*3","v":3678},{"$f":"IF(BC26=\"\",\"\",BC26)","v":3678},{"$nulls":4},{"$f":"BD26","v":3678},null,"2026-05-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL25),MONTH(BL25)+1,DAY(BL25))))),\"\")","v":"2026-05-01"},"DA Arrear 53% to 55%","","DA Arrear 53% to 55%",null,"DA Arrear 53% to 55%",{"$nulls":6},""]
[null,"TOTAL :",{"$f":"IF(AND($D$2=\"\",$M$2=\"\",$U$2=\"\",$C$3=\"\"),\"\",SUM(C6:C26))","v":781550},{"$f":"IF(AND($D$2=\"\",$M$2=\"\",$U$2=\"\",$C$3=\"\"),\"\",SUM(D6:D26))","v":448396},75000,0,0,0,0,0,6774,0,1311720,84000,95998,13236,10500,0,0,0,0,250,0,24000,0,227984,1083736,{"$nulls":19},"L-20",null,null,"DA Arrear 55% to 58%",{"$nulls":4},{"$f":"(ROUND((BA16*58%),0)-ROUND((BA16*55%),0))*3","v":5679},{"$f":"IF(BC27=\"\",\"\",BC27)","v":5679},{"$nulls":4},{"$f":"BD27","v":5679},null,"2026-06-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL26),MONTH(BL26)+1,DAY(BL26))))),\"\")","v":"2026-06-01"},"DA Arrear 55% to 58%","","DA Arrear 55% to 58%",null,"DA Arrear 55% to 58%",{"$nulls":6},""]
[{"$nulls":46},"L-21",null,null,"Fixation arear",{"$nulls":5},{"$f":"IF(BC28=\"\",\"\",BC28)","v":""},{"$nulls":6},"2026-07-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL27),MONTH(BL27)+1,DAY(BL27))))),\"\")","v":"2026-07-01"},"Fixation arear","","Fixation arear",null,"Fixation arear",{"$nulls":6},""]
[null,null,{"$f":"UPPER(IF('Master Data'!C4=\"\",\"\",'Master Data'!C4))","v":"HEERALAL JAT"},{"$nulls":15},{"$f":"IF(AND('Master Data'!E6=\"\"),\"\",CONCATENATE(\"( \",UPPER('Master Data'!E6), \" )\",))","v":"( USHA PALIYA )"},{"$nulls":27},"L-22",null,null,{"$f":"IF(BM29=\"\",\"\",BM29)","v":"PL Surrender Arrear"},{"$nulls":4},{"$f":"IF('Master Data'!$C$14=$AP$6,\"\",IF(AND(BA25=\"\"),\"\",IF(OR('Master Data'!C13=AW12),ROUND(2%*BA25,0),IF(OR('Master Data'!C13=AW16,'Master Data'!C13=AW17,'Master Data'!C13=AW18,'Master Data'!C13=AW19),ROUND(3%*BA25,0),\"\"))))","v":947},947,{"$nulls":4},{"$f":"BD29","v":947},null,"2026-08-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL28),MONTH(BL28)+1,DAY(BL28))))),\"\")","v":"2026-08-01"},"PL Surrender Arrear","","PL Surrender Arrear",null,"PL Surrender Arrear",{"$nulls":6},""]
[null,null,"Signature of Employee",{"$nulls":15},"Signature of DDO",{"$nulls":27},"L-23",null,null,{"$f":"IF(BM30=\"\",\"\",BM30)","v":"ACP/MACP Arrear"},{"$nulls":12},"2026-09-01",{"$f":"IFERROR(IF('Master Data'!$C$11=\"\",\"\",IF('Master Data'!$C$17=\"\",\"\",IF(AND($AZ$17>$AZ$9),\"\",DATE(YEAR(BL29),MONTH(BL29)+1,DAY(BL29))))),\"\")","v":"2026-09-01"},"ACP/MACP Arrear","","ACP/MACP Arrear",null,"",{"$nulls":6},""]
[{"$nulls":46},"L-24",{"$nulls":21},"",{"$nulls":6},""]
[{"$nulls":68},"",{"$nulls":6},""]
[{"$nulls":75},{"$f":"SUM(BX24:BX32)","v":0}]
{"$rows_empty":7}
[{"$nulls":49},{"$f":"IFERROR(IF(D23=\"\",\"\",IF(AND(D23=AX34),VLOOKUP(D23,om,4,0),IF(AND('[1]Master Data'!$I$28=$AP$6),'[1]Master Data'!$E$36,VLOOKUP(D23,om,4,0)))),\"\")","v":""}]

{"sheet":"COMPUTATION","index":3,"n_rows":73,"n_cols":34,"rows_kept":73,"merged":[[0,0,0,14],[1,2,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,14],[2,1,2,2],[2,3,2,7],[2,9,2,11],[2,13,2,14],[3,1,3,12],[4,1,4,12],[5,1,5,12],[6,0,9,0],[6,1,6,9],[6,10,6,12],[6,13,8,14],[7,1,7,9],[7,10,7,12],[8,1,8,9],[8,10,8,12],[9,1,9,9],[9,10,9,12],[10,1,10,12],[11,0,13,0],[11,1,11,7],[11,8,11,9],[11,10,11,12],[11,13,13,14],[12,1,13,2],[12,3,12,4],[12,5,12,7],[12,8,12,9],[12,10,12,12],[13,3,13,4],[13,5,13,7],[13,8,13,9],[13,10,13,12],[14,1,14,12],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,9,15,12],[16,1,16,3],[16,4,16,5],[16,6,16,7],[16,9,16,12],[17,1,17,12],[18,0,34,0],[18,1,18,14],[19,1,19,14],[20,2,20,4],[20,8,20,10],[20,13,30,14],[21,2,21,4],[21,8,21,10],[22,2,22,4],[22,8,22,10],[23,2,23,4],[23,8,23,10],[24,2,24,4],[24,8,24,10],[25,2,25,4],[25,8,25,10],[26,2,26,4],[26,8,26,10],[27,2,27,4],[27,8,27,10],[28,2,28,4],[28,8,28,10],[29,2,29,4],[29,8,29,10],[30,2,30,4],[30,7,30,10],[31,1,31,12],[32,1,32,12],[33,1,33,12],[34,1,34,12],[35,0,46,0],[35,1,35,14],[36,1,36,12],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[42,1,42,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[50,0,64,0],[50,1,50,14],[50,23,50,25],[50,27,50,29],[51,1,51,8],[51,9,51,13],[52,1,52,7],[52,9,52,11],[53,1,53,7],[53,9,53,11],[54,1,54,7],[54,9,54,11],[55,1,55,7],[55,9,55,11],[55,15,60,18],[56,1,56,7],[56,9,56,11],[57,1,57,7],[57,9,57,11],[59,1,59,7],[59,9,59,11],[60,1,60,12],[61,1,61,7],[61,9,61,11],[61,16,61,17],[62,1,62,12],[63,2,63,12],[64,1,64,12],[65,1,65,12],[66,1,66,12],[67,0,68,0],[67,1,68,3],[67,4,67,6],[67,7,67,8],[67,10,67,11],[67,12,67,13],[68,4,68,6],[68,7,68,8],[68,10,68,11],[68,12,68,13],[69,0,69,12],[70,1,70,9],[71,11,71,13]]}
[{"$f":"IF('Master Data'!C3=\"\",\"\",CONCATENATE(\"Office of the Principal\",\" , \",'Master Data'!C3))","v":"Office of the Principal , Mahatma Gandhi Government School (English Medium) Bar, (Beawar)"}]
[null,null,"आयकर गणना प्रपत्र वर्ष -",null,null,"2025-2026",null,"( कर निर्धारण वर्ष - ",null,"2026-2027)",null,"New Tax Regime"]
[1,"नाम कर्मचारी :-",null,{"$f":"IF('Master Data'!C4=\"\",\"\",UPPER('Master Data'!C4))","v":"HEERALAL JAT"},{"$nulls":4},"पद :-",{"$f":"IF('Master Data'!E4=\"\",\"\",UPPER('Master Data'!E4))","v":"SR. TEACHER"},null,null,"PAN :",{"$f":"IF('Master Data'!C7=\"\",\"\",UPPER('Master Data'!C7))","v":"ABCDE5555H"}]
[2,"आय : वर्ष  2025-26  में प्राप्त कुल आय ( कर योग्य मूल्यों सहित ) ",{"$nulls":11},"रु.",{"$f":"IF('GA55'!M27=\"\",\"\",'GA55'!M27)","v":1311720}]
[3,"गृह किराया धारा 10 (13-A) के अंतर्गत व धारा  10(14) के अंतर्गत भत्ते  तथा अन्य भत्ते जो कर मुक्त है I",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",SUM('Extra Ded. '!E6+'Extra Ded. '!K7+'GA55'!G27),0)","v":0}]
[4,"शेष ( 2-3) ",{"$nulls":11},"रु.",{"$f":"SUM(O4-O5)","v":1311720}]
[5,"  (i) मनोरंजन भत्ता धारा  16  (ii) के अंतर्गत  ( अधिकतम सीमा रू 5000 )",{"$nulls":8},{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E8,0)","v":0}]
[null," (ii) व्यवसाय कर  धारा  16  (iii) के अंतर्गत  ( अधिकतम सीमा रू 2500 )",{"$nulls":8},{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E9,0)","v":0}]
[null," (Iii) पारिवारिक पेंशन की मानक कटोती धारा 57 के अन्तगर्त ( अधिकतम सीमा रू 25000 )",{"$nulls":8},{"$f":"'Extra Ded. '!K11","v":0}]
[null,{"$f":"IF($L$2=\"Old Tax Regime\",CONCATENATE(\" (iii) स्टेण्डर्ड डिडेक्शन (Standard Deduction)\",\"  \",\"50,000 (अधिकतम)\"),CONCATENATE(\" (iii) स्टेण्डर्ड डिडेक्शन (Standard Deduction)\",\"  \",\"75,000 (अधिकतम)\"))","v":" (iii) स्टेण्डर्ड डिडेक्शन (Standard Deduction)  75,000 (अधिकतम)"},{"$nulls":8},{"$f":"IF($L$2=\"Old Tax Regime\",50000,75000)","v":75000},null,null,"रु.",{"$f":"SUM(K7:M10)","v":75000}]
[6,"                                                      शेष ( 4-5) ",{"$nulls":11},"रु.",{"$f":"SUM(O6-O10)","v":1236720}]
[7," गृह सम्पति से आय : (1) स्वयं के उपभोग में शून्य :-",{"$nulls":6},"(2) प्राप्त किराया रु .",null,{"$f":"'Extra Ded. '!E10","v":0}]
[null,"(ब) घटाइये",null,"किराये का 30%",null,"गृह ऋण पर ब्याज ",null,null,"गृह कर ",null,"योग 7 (ब)"]
[{"$nulls":3},{"$f":"IF($L$2=\"Old Tax Regime\",ROUND(K12*0.3,0),0)","v":0},null,{"$f":"IF($L$2=\"Old Tax Regime\",IF('Extra Ded. '!E13<200000,'Extra Ded. '!E13,200000),0)","v":0},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E11,0)","v":0},null,{"$f":"D14+F14+I14","v":0}]
[null,"शेष -/+  (7 (अ)  एवं योग 7 (ब) का ) :- ",{"$nulls":11},"रु.",{"$f":"K12-K14","v":0}]
[8,"बचत खाते पर ब्याज : ",null,null,{"$f":"'Extra Ded. '!K22","v":0},null,"अन्य स्रोत से आय :",null,{"$f":"'Extra Ded. '!E24","v":0},"कुल शेष - / + (6 एवं 7) :- ",{"$nulls":3},"रु.",{"$f":"O11+O15","v":1236720}]
[9,"एफडी व अन्य आय पर प्राप्त ब्याज राशि ",null,null,{"$f":"'Extra Ded. '!K25","v":0},null,"Bonds से प्राप्त ब्याज ",null,{"$f":"'Extra Ded. '!E23","v":0},"योग (8 + 9)  ",{"$nulls":3},"रु.",{"$f":"E16+E17+I16+I17","v":0}]
[10,"सकल आय ",{"$nulls":11},"रु.",{"$f":"O16+O17","v":1236720}]
[11,"घटाए कटोतियाँ :- धारा  US 80C, 80CCC,80CCD (1)  "]
[null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE), धारा 80CCD(2), तथा धारा 80CCD(1B) के अतिरिक्त"]
[null,"(i)","राज्य बीमा (SI)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'GA55'!N27,0)","v":0},"(xi)","पेंशन योजना में योगदान  ECPF धारा  80ccd(1)",null,null,"रु.",0]
[null,"(ii)","L.I.C.",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'GA55'!P27,0)","v":0},"(xii)","पेंशन प्लान हेतु योगदान  (धारा 80ccc)",null,null,"रु.",0]
[null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E18,0)","v":0},"(xiii)","राष्ट्रीय बचत पत्र पर अदत ब्याज ",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E19,0)","v":0}]
[null,"(iv)","लोक भविष्य निधि (PPF)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E20,0)","v":0},"(xiv)","टियुशन फ़ीस",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E16,0)","v":0}]
[null,"(v)","राष्ट्रीय बचत पत्र स्कीम (NSS)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E21,0)","v":0},"(xv)","इक्विटी लिंक सेविंग स्कीम ",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K6,0)","v":0}]
[null,"(vi)","सामान्य प्रावधायी निधि  GPF) / GPF - 2004",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'GA55'!O27,0)","v":0},"(xvi)","स्थगत वार्षिकी (Defferred Annuty)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K8,0)","v":0}]
[null,"(vii)","सामूहिक बीमा प्रीमियम  (G.Ins.)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'GA55'!Y27,0)","v":0},"(xvii)","पी.एल.आई . (PLI)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E15,0)","v":0}]
[null,"(viii)","यू एल आई पी / वार्षिक प्लान ",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E17,0)","v":0},"(xviii)","म्यूच्यूअल फण्ड व अन्य राशि जो धारा 80 C के अंतर्गत छुट  ",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K13,0)","v":0}]
[null,"(ix)","गृह ऋण किस्त (HBA Premium)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E12,0)","v":0},"(xix)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E22,0)","v":0}]
[null,"(x)","जीवन बीमा  (Extra LIC)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E14,0)","v":0},"(xx)","अन्य व फिक्स डिपोजिट  (5 वर्ष हेतु )",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K10,0)","v":0}]
[null,"(xxi)","उपरोक्त के अलावा अन्य कटोती (Other Ded.)",null,null,"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K12,0)","v":0},"योग  ( i से xxi )",{"$nulls":3},"रु.",{"$f":"SUM(G21:G31)+SUM(M21:M30)","v":0}]
[null,"अधिकतम कटोती राशि 1.50 लाख तक :- ",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",IF(M31<150001,ROUND(M31,0),150000),0)","v":0}]
[null,"(B) घटाइये धारा  80CCD(2) नियोक्ता द्वारा  पेंशन अंशदान की राशि  (अधिकतम वेतन का 10%)  पृथक से छुट ",{"$nulls":11},"रु.",0]
[null,"(B) घटाइये - धारा  80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान  (अधिकतम 50,000 रु. )",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K14,0)","v":0}]
[null,"योग 11(A+B)      ",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",SUM(O32:O34),0)","v":0}]
[12,"अन्य कटोतियाँ"]
[null,"1. धारा 80 D चिकित्सा बीमा प्रीमियम  (स्वयं पति पत्नि व बच्चों के लिए रु. 25,000 माता - पिता के लिए रु. 25,000 , सीनियर सिटीजन रु. 50,000 )",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K15,0)","v":0}]
[null,"2. धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता ( 1,25,000)",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K16,0)","v":0}]
[null,"3. धारा  80DDB विशिष्ट रोगों के उपचार हेतु छुट  (अधिकतम रु. 40,000, सीनियर सिटीजन हेतु रु. 1,00,000)",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K17,0)","v":0}]
[null,"4. धारा  80E उच्च शिक्षा हेतु लिए गए ऋण का ब्याज ",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K18,0)","v":0}]
[null,"5. धारा 80G धर्मार्थ संस्थाओ आदि को दिए दान ( क श्रेणी में  100 प्रतिशत एव ख श्रेणी में 50 प्रतिशत)   (केंद्र एव राज्य सरकार के फण्ड में )",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K19,0)","v":0}]
[null,"6. धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में  (अधिकतम  75,000 तथा अधिनियम 1995 के अनुसार 1,25,000)",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K21,0)","v":0}]
[null,"7. धारा 80 TTA बचत खाते पर अधिकतम ब्याज पर 10,000 194(IA),  एवं धारा 80 TTB  ( वरिष्ठ नागरिकों के लिए ब्याज पर छुट 50000 तक )",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",IF('Extra Ded. '!K22<10000,'Extra Ded. '!K22,10000),0)","v":0}]
[null,"8. धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान ",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!K23,0)","v":0}]
[null,"9. US 80EEA (Home Loan Interest)  & Others",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",'Extra Ded. '!E25,0)","v":0}]
[null,"10. US 80EEB Deduction in respect of purchase of electric vehicle.",{"$nulls":11},"रु."]
[null,"कुल योग 12 ( 1 से 10 तक )",{"$nulls":11},"रु.",{"$f":"SUM(O37:O46)","v":0}]
[13,"कुल कटोती ( 11 + 12)",{"$nulls":11},"रु.",{"$f":"O35+O47","v":0}]
[14,"कर योग्य आय ( 10 - 13 )",{"$nulls":11},"रु.",{"$f":"(O18-O48)","v":1236720}]
[15,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणांक में ) धारा  288A",{"$nulls":11},"रु.",{"$f":"ROUND(O49,-1)","v":1236720}]
[16,"आयकर की गणना उपर्युक्त कॉलम  15 के आधार पर ",{"$nulls":21},"old",{"$nulls":3},"New"]
[null,"पुरानी आयकर स्लैब ",{"$nulls":7},"नयी आयकर स्लैब ",{"$nulls":13},0,0,0,{"$f":"X52","v":0},0,0,0,{"$f":"AB52","v":0}]
[null,"Up to Rs. 2,50,000",{"$nulls":6},{"v":0,"d":"0%"},"Up to Rs. 4,00,000",null,null,{"v":0,"d":"0%"},"रु.",0,{"$nulls":8},{"$f":"ROUND(IF(O50<=250000,0,IF(O50>=500000,12500,IF(O50<=500000,0+(O50-250000)*0.05))),0)","v":12500},{"$f":"ROUND(IF(O50<=300000,0,IF(O50>=500000,10000,IF(O50<=500000,(O50-300000)*0.05))),0)","v":10000},0,{"$f":"X53","v":12500},{"$f":"ROUND(IF(O50<400001,0,IF(O50>800001,20000,((O50-400000)*0.05))),0)","v":20000},{"$f":"ROUND(IF(O50<400001,0,IF(O50>800001,20000,((O50-400000)*0.05))),0)","v":20000},{"$f":"ROUND(IF(O50<400001,0,IF(O50>800001,20000,((O50-400000)*0.05))),0)","v":20000},{"$f":"AB53","v":20000}]
[null,"2,50,001  to  5,00,000",{"$nulls":6},{"v":0.05,"d":"5%"},"4,00,001  to  8,00,000",null,null,{"v":0.05,"d":"5%"},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",AA53,AE53)","v":20000},{"$nulls":8},{"$f":"ROUND(IF(O50<=500000,0,IF(O50>=1000000,100000,IF(O50<=1000000,(O50-500000)*0.2,\"0\"))),0)","v":100000},{"$f":"ROUND(IF(O50<=500000,0,IF(O50>=1000000,100000,IF(O50<=1000000,(O50-500000)*0.2,\"0\"))),0)","v":100000},{"$f":"ROUND(IF(O50<=500000,0,IF(O50>=1000000,100000,IF(O50<=1000000,(O50-500000)*0.2,\"0\"))),0)","v":100000},100000,{"$f":"ROUND(IF(O50<800001,0,IF(O50>1200001,40000,((O50-800000)*0.1))),0)","v":40000},{"$f":"ROUND(IF(O50<800001,0,IF(O50>1200001,40000,((O50-800000)*0.1))),0)","v":40000},{"$f":"ROUND(IF(O50<800001,0,IF(O50>1200001,40000,((O50-800000)*0.1))),0)","v":40000},40000]
[null,"5,00,001 to 10,00,000",{"$nulls":6},{"v":0.2,"d":"20%"},"8,00,001  to  12,00,000",null,null,{"v":0.1,"d":"10%"},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",AA54,AE54)","v":40000},{"$nulls":8},{"$f":"ROUND(IF(O50>1000000,(O50-1000000)*0.3,\"0\"),0)","v":71016},{"$f":"ROUND(IF(O50>1000000,(O50-1000000)*0.3,\"0\"),0)","v":71016},{"$f":"ROUND(IF(O50>1000000,(O50-1000000)*0.3,\"0\"),0)","v":71016},71016,{"$f":"ROUND(IF(O50<1200001,0,IF(O50>1600001,60000,((O50-1200000)*0.15))),0)","v":5508},{"$f":"ROUND(IF(O50<1200001,0,IF(O50>1600001,60000,((O50-1200000)*0.15))),0)","v":5508},{"$f":"ROUND(IF(O50<1200001,0,IF(O50>1600001,60000,((O50-1200000)*0.15))),0)","v":5508},5508]
[null,"Above  10,00,000",{"$nulls":6},{"v":0.3,"d":"30%"},"12,00,001  to  16,00,000",null,null,{"v":0.15,"d":"15%"},"रु.",5508,"मार्जिनल रिलीफ बेनिफिट के लिए टैक्सेबल नेट अमाउंट को राउंड राशि में करने हेतु नीचे बॉक्स में सलेक्ट करें ",{"$nulls":10},0,{"$f":"ROUND(IF(O50<1600001,0,IF(O50>2000001,80000,((O50-1600000)*0.2))),0)","v":0},{"$f":"ROUND(IF(O50<1600001,0,IF(O50>2000001,80000,((O50-1600000)*0.2))),0)","v":0},{"$f":"ROUND(IF(O50<1600001,0,IF(O50>2000001,80000,((O50-1600000)*0.2))),0)","v":0},0]
[{"$nulls":9},"16,00,001  to  20,00,000",null,null,{"v":0.2,"d":"20%"},"रु.",0,{"$nulls":11},0,{"$f":"ROUND(IF(O50<2000001,0,IF(O50>2400001,100000,((O50-2000000)*0.25))),0)","v":0},{"$f":"ROUND(IF(O50<2000001,0,IF(O50>2400001,100000,((O50-2000000)*0.25))),0)","v":0},{"$f":"ROUND(IF(O50<2000001,0,IF(O50>2400001,100000,((O50-2000000)*0.25))),0)","v":0},0]
[{"$nulls":9},"20,00,001  to  24,00,000",null,null,{"v":0.25,"d":"25%"},"रु.",0,{"$nulls":12},{"$f":"ROUND(IF(O50<2400001,0,(O50-2400000)*0.3),0)","v":0},{"$f":"ROUND(IF(O50<2400001,0,(O50-2400000)*0.3),0)","v":0},{"$f":"ROUND(IF(O50<2400001,0,(O50-2400000)*0.3),0)","v":0},0]
[]
[{"$nulls":9},"Above  24,00,000",null,null,{"v":0.3,"d":"30%"},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"रु.\")","v":"रु."},{"$f":"IF($L$2=\"Old Tax Regime\",AA58,AE58)","v":0},{"$nulls":8},{"$f":"SUM(X52:X55)","v":183516},{"$f":"SUM(Y52:Y55)","v":181016},{"$f":"SUM(Z52:Z55)","v":171016},{"$f":"IF('[2]Master Data'!$E$24=\"Under 60\",X60,IF('[2]Master Data'!$E$24=\"Above 60\",Y60,Z60))","v":183516},{"$f":"SUM(AB52:AB59)","v":65508},{"$f":"SUM(AC52:AC59)","v":65508},65508,{"$f":"SUM(AE52:AE59)","v":65508}]
[null,"(1) योग आयकर ",{"$nulls":11},"रु.",{"$f":"SUM(O53:O60)","v":65508},{"$nulls":18},{"$f":"ROUND(IF(O50<250001,0,IF(O50>500000,12500,((O50-250000)*0.05))),0)+ROUND(IF(O50<500001,0,IF(O50>750000,25000,((O50-500000)*0.1))),0)+ROUND(IF(O50<750001,0,IF(O50>1000000,37500,((O50-750000)*0.15))),0)+ROUND(IF(O50<1000001,0,IF(O50>1250000,50000,((O50-1000000)*0.2))),0)+ROUND(IF(O50<1250001,0,IF(O50>1500000,62500,((O50-1250000)*0.25))),0)+ROUND(IF(O50<1500001,0,(O50-1500000)*0.3),0)","v":122344}]
[null,"(2) छुट धारा 87(A)  (पुरानी स्लैब में 5 लाख की कर योग्य आय पर छुट अधिकतम रु. 12500/- तक तथा नई आयकर स्लैब में 12 लाख तक की कर योग्य आय पर 60000/- तक छुट )",{"$nulls":6},{"$f":"IF($L$2=\"Old Tax Regime\",IF(O50>500000,0,IF(O61<12501,O61,12500)),AD72)","v":0},"Marginal relief benefit under section 115BAC(1)",null,null,{"$f":"IF($L$2=\"Old Tax Regime\",0,AD70)","v":28788},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",I62,SUM(I62+M62))","v":28788},null,"Net Taxable Amount",{"$nulls":6},{"$f":"ROUND(IF(O50<=250000,0,IF(O50<=500000,(O50-250000)*0.05,IF(O50<=1000000,12500+(O50-500000)*0.2,IF(O50>1000000,112500+(O50-1000000)*0.3,\"0\")))),0)","v":183516},{"$f":"ROUND(IF(O50<=300000,0,IF(O50<=500000,(O50-300000)*0.05,IF(O50<=1000000,10000+(O50-500000)*0.2,IF(O50>1000000,110000+(O50-1000000)*0.3,\"0\")))),0)","v":181016},{"$f":"ROUND(IF(O50<=250000,0,IF(O50<=500000,(O50-250000)*0.05,IF(O50<=1000000,0+(O50-500000)*0.2,IF(O50>1000000,100000+(O50-1000000)*0.3,\"0\")))),0)","v":171016}]
[null,"(3) शेष आयकर  (1-2)",{"$nulls":11},"रु.",{"$f":"O61-O62","v":36720},{"$nulls":9},{"$f":"IF(T66>350000,0,IF(T66<2501,T66,2500))","v":0}]
[null,"4)","शिक्षा एवं चिकित्सा उपकर  4% (आयकर पर )",{"$nulls":10},"रु.",{"$f":"ROUND((O63*0.04),0)","v":1469},{"$nulls":11},"round",null,null,"net"]
[null,"                                                             कुल आयकर  (3-4)",{"$nulls":11},"रु.",{"$f":"SUM(O63:O64)","v":38189},{"$nulls":10},{"$f":"O50","v":1236720},{"$f":"IF(Z65>1200000,Z65-1200000,0)","v":36720},null,{"$f":"O49","v":1236720},{"$f":"IF(AC65>1200000,AC65-1200000,0)","v":36720}]
[17," घटाइये :-   राहत धारा  89 के तहत  ",{"$nulls":11},"रु.",{"$f":"'Extra Ded. '!K24","v":0},{"$nulls":10},{"$f":"O61","v":65508},{"$f":"IF(Z65>1200000,Z66-0,0)","v":65508},null,{"$f":"O61","v":65508},{"$f":"IF(AC65>1200000,AC66-0,0)","v":65508}]
[18,"कुल शेष आयकर ",{"$nulls":11},"रु.",{"$f":"O65-O66","v":38189},{"$nulls":10},{"$f":"O64","v":1469},{"$f":"IF(AA66>AA65,AA66-AA65,0)","v":28788},null,{"$f":"O64","v":1469},{"$f":"IF(AD66>AD65,AD66-AD65,0)","v":28788}]
[19,"आयकर कटौती \n का विवरण ",null,null,"सितम्बर  2025\nतक कुल राशि ",null,null,"अक्टूम्बर 25 से दिसम्बर 25\nतक कुल राशि ",null,"जनवरी 2026\nराशि ","फरवरी 2026\nराशि ",null,"टी.डी.एस. \nकी राशि ",null,"कुलयोग कॉलम 19 ",{"$nulls":10},{"$f":"IF(Q62=Z71,AF69,AE69)","v":false}]
[{"$nulls":4},{"$f":"SUM('GA55'!BX12:BX18)","v":14000},null,null,{"$f":"SUM('GA55'!BX19:BX21)","v":6000},null,{"$f":"'GA55'!BX22","v":2000},{"$f":"'GA55'!BX23","v":2000},null,{"$f":"'GA55'!BX33","v":0},null,{"$f":"SUM(E69,H69,J69,K69,M69)","v":24000},{"$nulls":10},{"$f":"O65","v":38189},{"$f":"Z66-AA67","v":36720},null,null,{"$f":"IF(Q62=Z71,AF69,AE69)","v":false},false,true]
[{"$f":"IF(O67>O69,\"Income Tax Payable\",\"Income Tax Refundable\")","v":"Income Tax Payable"},{"$nulls":12},"रु.",{"$f":"IF(O67>O69,SUM(O67-O69),SUM(O69-O67))","v":14189},{"$nulls":14},{"$f":"IF(AD69=AF69,AA67,AD67)","v":28788}]
[null,"नोट :- नई कर व्यवस्था में मानक कटोती 75,000/- व नियोक्ता के अंशदान के अतिरिक्त अन्य कोई छूट देय नहीं है I ",{"$nulls":23},"Round Taxable Amount"]
[{"$nulls":11},"हस्ताक्षर कार्मिक ",{"$nulls":13},"Net Taxable Amount",{"$nulls":3},{"$f":"IF(AD69=AF69,IF(O50>1200004,0,IF(O61<60001,O61,60000)),AD73)","v":0}]
[{"$nulls":29},{"$f":"IF(AND(O49<1200005,M62=0),IF(O61<60001,O61,60000),0)","v":0}]

{"sheet":"Form No. 16","index":4,"n_rows":139,"n_cols":18,"rows_kept":139,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,5],[4,6,4,11],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,3],[7,4,7,5],[7,6,7,8],[7,9,7,11],[8,1,8,3],[8,4,8,5],[8,6,8,8],[8,9,8,11],[9,1,9,5],[9,6,9,7],[9,8,9,11],[10,2,10,5],[10,6,11,7],[10,8,10,9],[10,10,10,11],[11,2,11,3],[11,8,11,9],[11,10,11,11],[12,1,12,11],[13,2,13,4],[13,6,13,8],[13,9,13,11],[14,2,14,4],[14,6,14,8],[14,9,14,11],[15,2,15,4],[15,6,15,8],[15,9,15,11],[16,2,16,4],[16,6,16,8],[16,9,16,11],[17,2,17,4],[17,6,17,8],[17,9,17,11],[18,1,18,4],[18,6,18,8],[18,9,18,11],[19,1,19,11],[20,1,20,11],[21,1,22,1],[21,2,22,3],[21,4,21,11],[22,6,22,8],[22,9,22,11],[23,2,23,3],[23,6,23,8],[23,9,23,11],[24,2,24,3],[24,6,24,8],[24,9,24,11],[25,2,25,3],[25,6,25,8],[25,9,25,11],[26,2,26,3],[26,6,26,8],[26,9,26,11],[27,2,27,3],[27,6,27,8],[27,9,27,11],[28,2,28,3],[28,6,28,8],[28,9,28,11],[29,2,29,3],[29,6,29,8],[29,9,29,11],[30,2,30,3],[30,6,30,8],[30,9,30,11],[31,2,31,3],[31,6,31,8],[31,9,31,11],[32,2,32,3],[32,6,32,8],[32,9,32,11],[33,2,33,3],[33,6,33,8],[33,9,33,11],[34,2,34,3],[34,6,34,8],[34,9,34,11],[35,2,35,3],[35,6,35,8],[35,9,35,11],[36,2,36,3],[36,4,36,11],[37,1,37,11],[38,1,38,11],[39,1,40,1],[39,2,40,3],[39,4,39,11],[40,4,40,5],[40,6,40,7],[40,8,40,9],[40,10,40,11],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[53,2,53,3],[53,4,53,11],[54,1,54,11],[55,1,55,11],[56,2,56,4],[56,6,56,9],[56,10,56,11],[57,1,57,2],[57,3,57,5],[57,6,57,11],[58,3,58,7],[58,8,58,11],[59,1,59,11],[60,1,60,11],[61,1,61,2],[61,3,61,4],[61,5,61,11],[62,1,62,2],[62,3,62,4],[62,5,62,11],[63,1,63,2],[63,3,63,4],[63,6,63,11],[64,1,64,11],[65,1,65,11],[66,1,66,5],[66,6,66,7],[66,8,69,9],[66,10,80,11],[67,1,67,5],[67,6,67,7],[68,1,68,5],[68,6,68,7],[69,1,69,5],[69,6,69,7],[70,1,70,5],[70,6,73,7],[70,8,70,9],[71,1,71,5],[71,8,74,9],[72,1,72,5],[73,1,73,3],[74,1,74,3],[74,6,74,7],[75,1,75,5],[75,6,76,7],[75,8,75,9],[76,1,76,5],[76,8,79,9],[77,1,77,2],[77,3,77,5],[77,6,77,7],[78,1,78,2],[78,3,78,5],[78,6,78,7],[79,1,79,2],[79,3,79,5],[79,6,79,7],[80,1,80,5],[80,8,80,9],[81,1,81,5],[81,8,88,9],[81,10,81,11],[82,1,82,5],[82,10,84,11],[83,1,83,2],[83,3,83,4],[84,1,84,2],[84,3,84,4],[84,6,84,7],[85,1,85,2],[85,3,85,4],[85,6,85,7],[85,10,85,11],[86,1,86,5],[86,6,88,7],[87,1,87,4],[88,1,88,4],[89,1,89,4],[89,6,89,7],[89,8,89,9],[90,1,90,9],[90,10,90,11],[91,1,91,11],[92,1,92,11],[93,1,93,5],[93,6,93,7],[93,8,93,9],[93,10,93,11],[94,1,107,1],[94,3,106,3],[94,4,94,5],[94,6,94,7],[94,8,105,9],[94,10,105,11],[95,4,95,5],[95,6,95,7],[96,4,96,5],[96,6,96,7],[97,4,97,5],[97,6,97,7],[98,4,98,5],[98,6,98,7],[99,4,99,5],[99,6,99,7],[100,4,100,5],[100,6,100,7],[101,4,101,5],[101,6,101,7],[102,4,102,5],[102,6,102,7],[103,4,103,5],[103,6,103,7],[104,4,104,5],[104,6,104,7],[105,4,105,5],[105,6,105,7],[106,4,106,5],[106,6,106,7],[106,8,106,9],[106,10,106,11],[107,2,107,5],[107,6,107,7],[107,8,107,9],[107,10,107,11],[108,8,108,10],[109,1,109,11],[110,1,110,5],[110,6,110,7],[110,8,110,9],[110,10,110,11],[111,2,111,5],[111,6,111,7],[111,8,111,9],[111,10,118,11],[112,2,112,5],[112,6,112,7],[112,8,112,9],[113,2,113,5],[113,6,113,7],[113,8,113,9],[114,2,114,5],[114,6,114,7],[114,8,114,9],[115,2,115,5],[115,6,115,7],[115,8,115,9],[116,2,116,5],[116,6,116,7],[116,8,116,9],[117,2,117,5],[117,6,117,7],[117,8,117,9],[118,2,118,5],[118,6,118,7],[118,8,118,9],[119,2,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11],[120,1,120,9],[120,10,120,11],[121,1,121,3],[121,4,121,9],[121,10,121,11],[122,1,122,9],[122,10,122,11],[123,1,123,9],[123,10,123,11],[124,1,124,9],[124,10,124,11],[125,1,125,9],[125,10,125,11],[126,1,126,9],[126,10,126,11],[127,1,127,9],[127,10,127,11],[128,1,128,9],[128,10,128,11],[129,1,129,9],[129,10,129,11],[130,1,130,9],[130,10,130,11],[131,1,131,11],[132,2,132,4],[132,6,132,9],[132,10,132,11],[133,1,133,2],[133,3,133,5],[133,6,133,11],[134,3,134,7],[134,8,134,11],[135,1,135,11],[136,1,136,2],[136,3,136,4],[136,5,136,11],[137,1,137,2],[137,3,137,4],[137,5,137,11],[138,1,138,2],[138,3,138,4],[138,6,138,11]]}
[null,"FORM NO. 16"]
[null,"[(See Rule 31(1)(a)]"]
[null,"PART-A"]
[null,"Certificate under section 203 of the income-tax act, 1961 for Tax deducted at source on Salary."]
[null,"Name and address of the Employer",{"$nulls":4},"Name and adress of the Employee"]
[null,{"$f":"IF('Master Data'!E6=\"\",\"\",UPPER('Master Data'!E6))","v":"USHA PALIYA"},{"$nulls":4},{"$f":"IF('Master Data'!C4=\"\",\"\",UPPER('Master Data'!C4))","v":"HEERALAL JAT"}]
[{"$nulls":6},{"$f":"IF('Master Data'!C6=\"\",\"\",UPPER('Master Data'!C6))","v":"MGGS BAR"}]
[null,"PAN of the Deductor",null,null,"TAN of  the Deductor",null,"PAN of the Employee",null,null,"Employee Ref No."]
[{"$nulls":6},{"$f":"IF('Master Data'!C7=\"\",\"\",UPPER('Master Data'!C7))","v":"ABCDE5555H"},null,null,{"$f":"IF('Master Data'!E7=\"\",\"\",UPPER('Master Data'!E7))","v":"51XXXXXXXXX96"}]
[null,"CIT (TDS)",{"$nulls":4},"Assess. Year",null,"Peroid with the Employer"]
[null,"Adress","The Commissioner of Income Tax, Pali",{"$nulls":3},"2026-27",null,"From",null,"To"]
[null,"City","PALI",null,"PIN Code",306401,null,null,"01-4-2025",null,"31-03-2026"]
[null,"Summary of amount paid/credited and tax deducted at source thereon in respect of the employee"]
[null,"Quarters","Receipt Numbers of original quarterly statements of TDS under sub-secion (3) of section 200",null,null,"Amount paid/ credited","Amount of tax deducted (Rs.)",null,null,"Amount of tax deposited/ remitted (Rs.)",{"$nulls":7},"SHEET PASSWORD"]
[null,"1st ",{"$nulls":4},{"$f":"SUM('GA55'!BX12:BX14)","v":{"v":6000,"d":"Rs. 6,000"}},null,null,{"$f":"G15+F15","v":{"v":6000,"d":"Rs. 6,000"}},{"$nulls":7},"IT#M$2025"]
[null,"2nd ",{"$nulls":4},{"$f":"SUM('GA55'!BX15:BX17)","v":{"v":6000,"d":"Rs. 6,000"}},null,null,{"$f":"G16+F16","v":{"v":6000,"d":"Rs. 6,000"}}]
[null,"3rd  ",{"$nulls":4},{"$f":"SUM('GA55'!BX18:BX20)","v":{"v":6000,"d":"Rs. 6,000"}},null,null,{"v":6000,"d":"Rs. 6,000"}]
[null,"4th ",{"$nulls":4},{"$f":"SUM('GA55'!BX21:BX23)+SUM('GA55'!BX33)","v":{"v":6000,"d":"Rs. 6,000"}},null,null,{"v":6000,"d":"Rs. 6,000"}]
[null,"TOTAL (Rs.)",{"$nulls":3},{"$f":"SUM(F15:F18)","v":{"v":0,"d":"Rs. 0"}},{"$f":"SUM(G15:G18)","v":{"v":24000,"d":"Rs. 24,000"}},null,null,{"$f":"SUM(J15:J18)","v":{"v":24000,"d":"Rs. 24,000"}}]
[null,"I. Details of tax deducted and deposited in the Central Government account through book adjustment"]
[null,"(The Deductor to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
[null,"S.N.","Tax Deposited in respect of the deductee (Rs)",null,"Book identification number (BIN)"]
[{"$nulls":4},"Receipt numbers of form No. 24G","DDO serial number in Form No. 24G","Date of transfer voucher (dd/mm/yyyy)",null,null,"Status of matching with Form No. 24G"]
[null,1,{"$f":"'GA55'!BX12","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},{"$f":"IF(E24>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,2,{"$f":"'GA55'!BX13","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},{"$f":"IF(E25>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,3,{"$f":"'GA55'!BX14","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,4,{"$f":"'GA55'!BX15","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,5,{"$f":"'GA55'!BX16","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,6,{"$f":"'GA55'!BX17","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,7,{"$f":"'GA55'!BX18","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,8,{"$f":"'GA55'!BX19","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,9,{"$f":"'GA55'!BX20","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,10,{"$f":"'GA55'!BX21","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,11,{"$f":"'GA55'!BX22","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,12,{"$f":"'GA55'!BX23","v":{"v":2000,"d":"Rs. 2,000"}},{"$nulls":6},"-"]
[null,13,{"$f":"'GA55'!BX33","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,"Total",{"$f":"SUM(C24:D36)","v":{"v":24000,"d":"Rs. 24,000"}}]
[null,"II. Details of Tax deducted and deposited in Central Government Account through Challan. "]
[null,"(The deducter to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
[null,"S.N.","Tax Deposited in respect on of the deductee (Rs)",null,"Challan identification number (CIN)"]
[{"$nulls":4},"BSR code of the Bank Branch",null,"Date on which tax deposited (dd/mm/yyyy)",null,"Challan Serial Number",null,"Status of matching with OLTAS"]
[null,1,{"$nulls":8},{"$f":"IF(C42>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,2,{"$nulls":8},{"$f":"IF(C43>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,3,{"$nulls":8},"-"]
[null,4,{"$nulls":8},"-"]
[null,5,{"$nulls":8},"-"]
[null,6,{"$nulls":8},"-"]
[null,7,{"$nulls":8},"-"]
[null,8,{"$nulls":8},"-"]
[null,9,{"$nulls":8},"-"]
[null,10,{"$nulls":8},"-"]
[null,11,{"$nulls":8},"-"]
[null,12,{"$nulls":8},"-"]
[null,"Total",{"$f":"SUM(C42:D53)","v":0}]
[null,":: 2 ::"]
[null,"Verification"]
[null,"I",{"$f":"B6&\",\"","v":"USHA PALIYA,"},null,null,"Son/Daughter of ",{"$nulls":4},"working in the "]
[null,"capacity of ",null,"PRINCIPAL",null,null,"(designation) do hereby certify that a sum of "]
[null,"Rs. -",{"$f":"J19","v":24000},{"$f":"IF(OR(LEN(FLOOR(C59,1))=13,FLOOR(C59,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(C59>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(C59,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",C59,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\" Paise\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\" Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[3]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\" Paise\",\"\")))))))","v":"Twenty-Four Thousand  Rupees"},{"$nulls":4},"(in words) has been deducted "]
[null,"and deposited to the credit of the Central Govt.. I further certify that the information given above is true, complete and correct "]
[null,"and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
[null,"Place",null,{"$f":"G7","v":"MGGS BAR"}]
[null,"Date",null,{"$f":"TODAY()","v":"2025-11-14"},null,"Signature of person responsible for deduction of tax"]
[null,"Designation",null,{"$f":"D58","v":"PRINCIPAL"},null,"Full name :",{"$f":"B6","v":"USHA PALIYA"}]
[null,"PART- B (Annexure)"]
[null,"DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[null,"1. Gross salary"]
[null,"(a) Salary as per provisions contained in section 17(1)",{"$nulls":4},{"$f":"COMPUTATION!O4","v":{"v":1311720,"d":"Rs. 1,311,720.00"}}]
[null,"(b) Value of perquisites u/s 17(2) (as per Form No. 12BA, wherever applicable)"]
[null,"(c) Profits in lieu of salary under section 17(3) (as per Form No. 12BA, wherever applicable)",{"$nulls":4},0]
[null,"(d) Total  (a+b+c)",{"$nulls":6},{"$f":"G68+G69+G70","v":{"v":1311720,"d":"Rs. 1,311,720.00"}}]
[null,"2. Less: Allowance to the extent exempt u/s 10 House Rent Allowance"]
[null,"Allowance"]
[null,"House Rent Allow. US10 (13 A)",null,null,{"$f":"COMPUTATION!O5","v":0},{"$f":"E74","v":0}]
[null,"US10 (14)",{"$nulls":3},0,{"$f":"F74+F75","v":0}]
[null,"3. Balance (1 - 2)",{"$nulls":6},{"$f":"I71-G75","v":{"v":1311720,"d":"Rs. 1,311,720.00"}}]
[null,"4. Deductions: U/s 16"]
[null,"(a)",null,"Standard Deduction (u/s 16 (ia)",null,null,{"$f":"COMPUTATION!K10","v":{"v":75000,"d":"Rs. 75,000.00"}}]
[null,"(b)",null,"Entertainment allowance",null,null,{"$f":"COMPUTATION!K7","v":0}]
[null,"(c)",null,"Tax on employment",null,null,{"$f":"COMPUTATION!K8","v":0}]
[null,"5. Aggregate of 4 (a) and (b)",{"$nulls":6},{"$f":"G79+G80+G78","v":{"v":75000,"d":"Rs. 75,000.00"}}]
[null," Income chargeable under the head \"salaries\" (3-5)",{"$nulls":8},{"$f":"I76-I81","v":{"v":1236720,"d":"Rs. 1,236,720.00"}}]
[null,"6. Income From House Property (a + b)"]
[null,"30% of Rent",null,"Interest on Home Loan",null,"house Tax"]
[null,{"$f":"COMPUTATION!D14","v":0},null,{"$f":"COMPUTATION!F14","v":0},null,{"$f":"COMPUTATION!I14","v":0},{"$f":"SUM(B85+D85+F85)","v":0}]
[null,"(a) Received House Rent",null,{"$f":"COMPUTATION!K12","v":0},null,"Total (a-b)   +-",{"$f":"SUM(D86-G85)","v":0},{"$nulls":3},{"$f":"K82+G86","v":{"v":1236720,"d":"Rs. 1,236,720.00"}}]
[null,"7. Add: Any other income reported by employee "]
[null,"FD व  अन्य स्रोत से प्राप्त ब्याज तथा Bond से प्राप्त ब्याज ",{"$nulls":3},{"$f":"COMPUTATION!I17","v":0}]
[null,"अन्य स्रोत से आय :",{"$nulls":3},{"$f":"COMPUTATION!I16","v":0}]
[null,"Saving Bank A/C interest",{"$nulls":3},{"$f":"COMPUTATION!E16","v":0},{"$f":"F88+F89+F90","v":0},null,{"$f":"F88+F89+F90","v":0}]
[null,"8. Gross total income (6+7)",{"$nulls":8},{"$f":"K86+I90","v":{"v":1236720,"d":"Rs. 1,236,720.00"}}]
[null,"9. Deductions under Chapter VI A"]
[null,"(A) Section 80C, 80CCC and 80CCD"]
[null,"(a) Section 80C",{"$nulls":6},"Gross Amount",null,"Deductible Amount"]
[null,"A",1,"(A)",{"$f":"COMPUTATION!C26","v":"सामान्य प्रावधायी निधि  GPF) / GPF - 2004"},null,{"$f":"COMPUTATION!G26","v":0}]
[null,null,2,null,"State Insurance",null,{"$f":"COMPUTATION!G21","v":0}]
[null,null,3,null,"Gr. Acc. Insurance",null,{"$f":"COMPUTATION!G27","v":0}]
[null,null,4,null,"LIC + ULIP + PLI",null,{"$f":"COMPUTATION!G22+COMPUTATION!G30+COMPUTATION!G28+COMPUTATION!M27","v":0}]
[null,null,5,null,"PPF",null,{"$f":"COMPUTATION!G24","v":0}]
[null,null,6,null,"Home Loan Installment (Capital)",null,{"$f":"COMPUTATION!G29","v":0}]
[null,null,7,null,"Equity link saving schame + Defferred Annuty",null,{"$f":"COMPUTATION!M25+COMPUTATION!M26","v":0}]
[null,null,8,null,"Pension Plan (US80ccc+US 80CCD)(1)",null,{"$f":"COMPUTATION!M21+COMPUTATION!M22","v":0}]
[null,null,9,null,"Tution Fee",null,{"$f":"COMPUTATION!M24","v":0}]
[null,null,10,null,"NSC + Interest on NSC",null,{"$f":"COMPUTATION!G25+COMPUTATION!M23","v":0}]
[null,null,11,null,"Sukanya Samridhi A/C",null,{"$f":"COMPUTATION!M29","v":0}]
[null,null,12,null,"Fixed Deposit above 5 years",null,{"$f":"COMPUTATION!M30","v":0}]
[null,null,13,null,"Mutual Fund",null,{"$f":"COMPUTATION!M28","v":0},null,{"$f":"SUM(G95:H108)","v":0},null,{"$f":"IF(I107<=150000, I107, 150000)","v":0}]
[null,null,"उपरोक्त के अलावा अन्य कटोती 80 C के अंतर्गत  (Other Ded.)",{"$nulls":3},{"$f":"COMPUTATION!G31","v":0},null,"Total Deducation :",null,{"$f":"SUM(K107+G108)","v":0}]
[{"$nulls":8},"………………… 3"]
[null,":: 3 ::"]
[null,"(B) Other Sections (e.g. 80E, 80G etc.) under Chapter VIA",{"$nulls":4},"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
[null,1,"U/S 80D",{"$nulls":3},{"$f":"COMPUTATION!O37","v":0},null,{"$f":"G112","v":0}]
[null,2,"U/S 80DD",{"$nulls":3},{"$f":"COMPUTATION!O38","v":0},null,{"$f":"G113","v":0}]
[null,3,"U/S 80DDB",{"$nulls":3},{"$f":"COMPUTATION!O39","v":0},null,0]
[null,4,"U/S 80E",{"$nulls":3},{"$f":"COMPUTATION!O40","v":0},null,0]
[null,5,"U/S 80G",{"$nulls":3},{"$f":"COMPUTATION!O41","v":0},null,0]
[null,6,"U/S 80GGA",{"$nulls":3},{"$f":"COMPUTATION!O44","v":0},null,0]
[null,7,"U/S 80 EE & US 80EEA  & Others",{"$nulls":3},{"$f":"COMPUTATION!O45","v":0},null,0]
[null,8,"U/S 80U",{"$nulls":3},{"$f":"COMPUTATION!O42","v":0},null,0]
[null,9,"US 80TTA [Exempt Saving Bank Int. Max. RS. 10,000/-]",{"$nulls":3},{"$f":"COMPUTATION!O43","v":0},null,{"$f":"G120","v":0},null,{"$f":"ROUND(SUM(I112:J120),0)","v":0}]
[null,"10. Aggregate of deductible amount under chapter VIA ",{"$nulls":8},{"$f":"ROUND((K108+K120),0)","v":0}]
[null,"11. Total income (8-10)",null,null,"(Roundup Figures of Rs 10)",{"$nulls":5},{"$f":"ROUND((K91-K121),-1)","v":{"v":1236720,"d":"Rs. 1,236,720.00"}}]
[null,"12. Tax on total income",{"$nulls":8},{"$f":"COMPUTATION!O61","v":{"v":65508,"d":"Rs. 65,508.00"}}]
[null,"13. Rebate U/s 87 A (Taxable Income below Rs. 5,00,000/- in Old Regime , below Rs. 12,00,000/- in New Regime) & Marginal relief benefit",{"$nulls":8},{"$f":"COMPUTATION!O62","v":{"v":28788,"d":"Rs. 28,788.00"}}]
[null,"14. Tax payable (12-13)",{"$nulls":8},{"$f":"K123-K124","v":{"v":36720,"d":"Rs. 36,720.00"}}]
[null,"15. Education & Health cess @ 4% (on tax computed at S.No. 12)",{"$nulls":8},{"$f":"ROUND((K125*0.04),0)","v":{"v":1469,"d":"Rs. 1,469.00"}}]
[null,"16. Tax payable (14+15) [Round off U/s 288 B]",{"$nulls":8},{"$f":"K125+K126","v":{"v":38189,"d":"Rs. 38,189.00"}}]
[null,"17. Less:- Relief under section 89 (Attach Form 10E)",{"$nulls":8},{"$f":"COMPUTATION!O66","v":0}]
[null,"18. Tax payable (14-15)",{"$nulls":8},{"$f":"K127-K128","v":{"v":38189,"d":"Rs. 38,189.00"}}]
[null,"19. Tax deducted at source u/s 192 (1)",{"$nulls":8},{"$f":"COMPUTATION!O69","v":{"v":24000,"d":"Rs. 24,000.00"}}]
[null,{"$f":"IF(K129>K130,\"Income Tax Payable\",IF(K129<K130,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":8},{"$f":"IF(K129>K130,K129-K130,K130-K129)","v":{"v":14189,"d":"Rs. 14,189.00"}}]
[null,"Verification"]
[null,"I",{"$f":"B6&\",\"","v":"USHA PALIYA,"},null,null,"Son/Daughter of ",{"$f":"IF(G57=\"\",\"\",G57)","v":""},{"$nulls":3},"working in the "]
[null,"capacity of ",null,{"$f":"D58","v":"PRINCIPAL"},null,null,"(designation) do hereby certify that a sum of "]
[null,"Rs.",{"$f":"K130","v":24000},{"$f":"D59","v":"Twenty-Four Thousand  Rupees"},{"$nulls":4},"(in words) has beeen deducted and "]
[null,"deposited to the  credit of the Central Government. I further certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
[null,"Place",null,{"$f":"D62","v":"MGGS BAR"}]
[null,"Date",null,{"$f":"TODAY()","v":"2025-11-14"},null,"Signature of person responsible for deduction of tax"]
[null,"Designation",null,{"$f":"D134","v":"PRINCIPAL"},null,"Full name :",{"$f":"B6","v":"USHA PALIYA"}]