{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instruction","Master","GA 55 Editable","Other Ded.","Summary","GA 55 For Print","Tax Calculaton Old","Tax Calculaton New"],"not_rendered":{"images":3,"macros":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Instruction","index":0,"n_rows":68,"n_cols":3,"rows_kept":68,"hidden":true,"merged":[[0,0,0,6],[2,0,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[31,0,31,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[38,1,38,6],[39,1,39,6],[40,1,40,6],[41,1,41,6],[42,1,42,6],[43,1,43,6],[44,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[52,1,52,6],[53,1,53,6],[54,1,54,6],[55,1,55,6],[56,1,56,6],[57,1,57,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[63,1,63,6],[64,1,64,6],[65,1,65,6],[66,1,66,6],[67,1,67,6]]}
["आयकर गणना प्रपत्र 2021-22"]
[]
["Master Sheet Instruction"]
[1,"Employee Name","अपना नाम लिखिए"]
[2,"Post","अपनी पोस्ट ड्राप डाउन लिस्ट में से चयन करे |"]
[3,"Cader","अपना कैडर चयन करे |"]
[4,"Are you in Probation","अगर आप प्रोबेशन में है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[5,"PAY-Level","अपना पे लेवल का चयन ड्राप डाउन लिस्ट में से करे |"]
[6,"Employee ID","अपनी एम्प्लोयी आईडी लिखिए |"]
[7,"PAN NO.","अपना पैन नंबर लिखिए |"]
[8,"SI No.","अपने एस.आई. नंबर लिखिए |"]
[9,"GPF/PRAN No.","अपने GPF या PRAN नंबर लिखिए |"]
[10,"Bank Account No.","अपने बैंक अकाउंट नंबर लिखिए |"]
[11,"Mobile No.","अपने मोबाइल नंबर लिखिए |"]
[12,"मार्च का बेसिक","आपका मार्च का बेसिक लिखिये |"]
[13,"HRA Rate","अपनी हाउस रेंट का प्रतिशत ड्राप डाउन में से चयन करे | "]
[14,"SIP (Monthly Amount)","एस.आई. का मासिक अमाउंट लिखिए |"]
[15,"SI Loan (Monthly Amount)","एस.आई. लोन का मासिक अमाउंट लिखिए |"]
[16,"GPF (Monthly Amount)","GPF का मासिक अमाउंट लिखिए |"]
[17,"GPF Loan (Monthly Amount)","GPF लोन का मासिक अमाउंट लिखिए |"]
[18,"Are You NPS Employee","यदि आप NPS एम्प्लोई है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[19,"बोनस मिला या नहीं","यदि आपको बोनस मिला है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[20,"बोनस कितने माह का","यदि बोनस मिला है तो कितने महीने का मिला है ड्राप डाउन लिस्ट में से चयन करे |"]
[21,"DA Arrear मिला या नहीं","यदि आपको DA Arrear  मिला है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[22,"समर्पित 19-20 उठाया या नहीं","यदि आपने सत्र 2019-20 में समर्पित उठाया  है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[23,"समर्पित 19-20 कौनसे माह में उठाया","सत्र 2019-20 में समर्पित कौनसे माह में उठाया उस माह का क्रमांक भरे |"]
[24,"60-80 वर्ग","यदि आप 60-80 वर्ष की आयु वर्ग के है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[25,"समर्पित 20-21  उठाया या नहीं","यदि आपने सत्र 2020-21 में समर्पित उठाया  है तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[26,"समर्पित 20-21 कौनसे माह में उठाया","सत्र 2020-21 में समर्पित कौनसे माह में उठाया उस माह का क्रमांक भरे |"]
[27,"क्या आप Covid-19 कटौती रखना चाहते है","यदि आप Covid-19 की कटौती जारी रखना चाहते हो तो ड्राप डाउन में से YES का चयन करे अन्यथा NO का चयन करे |"]
[]
["Other Ded. Sheet Instruction"]
[1,"मकान किराया भत्ता ( छूट जो लेनी है) "]
[2,"गृह सम्पति से प्राप्त किराया - आय"]
[3,"गृहकर "]
[4,"सरकारी पेंशन योजना में कर्मचारी का अंशदान अधिकतम वेतन का 10% धारा 80 CCD(1)"]
[5,"Covid - 19 (धारा 80G)"]
[6,"गृह ऋण किस्त मूल (जो वेतन से नहीं काटा गया)"]
[7,"गृह ऋण किस्त ब्याज (जो वेतन से नहीं काटा गया)"]
[8,"LIC जीवन बीमा प्रीमियम (जो वेतन से नही काटा गया)"]
[9,"PLI (पी.एल.आई.)"]
[10,"टयूशन फीस"]
[11,"PPF (लोक भविष्य निधि)"]
[12,"सुकन्या समृद्धि योजना"]
[13,"यू. एल. आई. पी./वार्षिक प्लान"]
[14,"NSS (राष्ट्रीय बचत स्कीम)"]
[15,"NSC (राष्ट्रीय बचत पत्र)"]
[16,"राष्ट्रीय बचत पत्र पर ब्याज"]
[17,"बचत खाते की जमा राशि पर प्राप्त ब्याज"]
[18,"इक्विटी लिंक सेविंग स्कीम"]
[19," Defferred Annuty (स्थगित वार्षिकी)"]
[20,"मनोरंजन भता धारा 16 (II) के अन्तर्गत "]
[21,"व्यवयाय कर धारा 16 (III) के अन्तगर्त "]
[22,"एफडी आदि अन्य जमा राशि पर प्राप्त कुल ब्याज (पीपीएफ को छोड़कर)"]
[23,"अन्य विभिन्न स्त्रो़त्र (ब्याज के अलावा) से कुल आय"]
[24,"धारा 80 सी के अन्तर्गत अन्य मद में जमा करायी गयी राशि"]
[25,"धारा 80 CCC पेंशन प्लान हेतु अंशदान (एन.पी.एस. के अलावा)"]
[26,"धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)"]
[27,"धारा 80D चिकित्सा बीमा प्रीमियम (सामान्य 25000, वरिष्ठ नागरिक 50000)"]
[28,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार(अधिकतम 75000, 80% विकलांगता 125000)"]
[29,"धारा 80DDB विशिष्ट रोगों के उपचार हेतु कटौती (सामान्य 40000, वरिष्ठ नागरिक 1 लाख)"]
[30,"धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज"]
[31,"धारा 80U स्थाई शारीरिक विकलांगता (अधिकतम 75000ए 80% विकलांगता 125000)"]
[32,"धारा 80GGA अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास हेतु दिया गया दान"]
[33,"राहत धारा 89 के अन्तर्गत"]
[34,"वेतन बिल के अलावा जमा कराया गया आयकर (TDS)"]
[35,"धारा 10(14) के अन्तर्गत भत्ते जो करमुक्त है"]
[36,"धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी 100% एवं ख श्रेणी 50%)"]

{"sheet":"Master","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[0,0,0,5],[1,0,1,5]]}
["Office of the Principal DIET Kuchaman City (Nagaur)"]
["आयकर गणना प्रपत्र 2021-22"]
[]
["Employee Name","Ashwini Kumar Sharma","Post","Lecturer","Cader","State Service"]
["Are you in Probation","No","PAY-Level","L-12","Employee ID","RJNA201228008021"]
["PAN NO.","AAAA9456A","SI No.",123456,"GPF/PRAN No.","1234567891011"]
["Bank Account No.","123456789101112","Mobile No.",9166023711,"March 2021 Basic",{"v":52300,"d":"52300.00"}]
["HRA Rate",{"v":0.08,"d":"8%"},"SIP (Monthly Amount)",{"v":3000,"d":"3000.00"},"SI Loan (Monthly Amount)",{"v":0,"d":"0.00"}]
["GPF (Monthly Amount)",{"v":5100,"d":"5100.00"},"GPF Loan (Monthly Amount)",{"v":0,"d":"0.00"},"Are You NPS Employee","Yes"]
["Washing All. Monthly",{"v":0,"d":"0.00"},"Handi. All. Monthly",{"v":0,"d":"0.00"},"CCA (Monthly Amount)",{"v":0,"d":"0.00"}]
["बोनस मिला या नहीं","Yes","बोनस कितने माह का",12,"60-80 वर्ग","No"]
["समर्पित 21-22  उठाया या नहीं","No","समर्पित 20-21 कौनसे माह में उठाया",null,"TAN No.","ABCD1234E"]
["क्या आपने RGHS की कटौती विकल्प लिया है (For NPS)","YES","GIS Slab",220,"LIC Amount"]

{"sheet":"GA 55 Editable","index":2,"n_rows":31,"n_cols":31,"rows_kept":31,"merged":[[0,1,0,26],[1,1,1,26],[3,2,3,5],[3,7,3,9],[3,11,3,12],[3,13,3,14],[3,15,3,18],[3,19,3,21],[3,22,3,23],[3,25,3,26],[4,2,4,5],[4,7,4,9],[4,11,4,12],[4,13,4,14],[4,15,4,18],[4,19,4,21],[4,22,4,25],[30,1,30,3],[30,24,30,25]]}
[null,{"$f":"Master!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
[null,"Salary and Deduction Detail for FY : 2021-22"]
[]
[null,"नाम कर्मचारी-",{"$f":"IF(Master!B4=0,0,Master!B4)","v":"Ashwini Kumar Sharma"},{"$nulls":3},"पद-",{"$f":"IF(Master!D4=0,0,Master!D4)","v":"Lecturer"},null,null,"लेवल-",{"$f":"IF(Master!D5=0,0,Master!D5)","v":"L-12"},null,"Employee ID-",null,{"$f":"IF(Master!F5=0,0,Master!F5)","v":"RJNA201228008021"},{"$nulls":3},"मार्च का बेसिक-",null,null,{"$f":"IF(Master!F7=0,0,Master!F7)","v":{"v":52300,"d":"52300.00"}},null,"TAN No.",{"$f":"IF(Master!F12=0,0,Master!F12)","v":"ABCD1234E"}]
[null,"पैन नं.-",{"$f":"IF(Master!B6=0,0,Master!B6)","v":"AAAA9456A"},{"$nulls":3},"Mobile-",{"$f":"IF(Master!D7=0,0,Master!D7)","v":9166023711},null,null,"SI No.-",{"$f":"IF(Master!D6=0,0,Master!D6)","v":123456},null,"GPF/PRAN No.-",null,{"$f":"IF(Master!F6=0,0,Master!F6)","v":"1234567891011"},{"$nulls":3},"बैंक खाता सं.-",null,null,{"$f":"IF(Master!B7=0,0,Master!B7)","v":"123456789101112"}]
[null,"Month & Year","Basic Pay","DA","HRA","Washing Allow.","Handicaped Allowance","CCA Allowance","Other Allowance","Gross Salary","SIP","GPF","NPS","GPF Loan","RPMF","SI Arrear","SI Loan","GIS","LIC","COVIS-19","GPF 2004","Hitkari Nidhi","Other","ITAX","Total Deduction","NET Payment","Bill No./ Dte"]
[3,"2021-03-01",{"$f":"IF(Master!F7=0,0,Master!F7)","v":{"v":52300,"d":"52,300"}},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C7=0,0,ROUND(C7*17%,0)))","v":{"v":8891,"d":"8,891"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.08*C7,0),ROUND(0.16*C7,0)))","v":{"v":4184,"d":"4,184"}},{"$f":"IF(Master!$B$10=0,0,Master!$B$10)","v":0},{"$f":"IF(Master!$D$10=0,0,Master!$D$10)","v":0},{"$f":"IF(Master!$F$10=0,0,Master!$F$10)","v":0},null,{"$f":"SUM(C7:I7)","v":{"v":65375,"d":"65,375"}},{"$f":"IF(Master!D8=0,0,Master!D8)","v":{"v":3000,"d":"3,000"}},{"$f":"IF(Master!$F$9=\"YES\",0,IF(Master!$B$9=0,0,Master!$B$9))","v":0},{"$f":"IF(Master!$F$9=\"YES\",ROUND((C7+D7)*0.1,0),0)","v":{"v":6119,"d":"6,119"}},{"$f":"IF(Master!$D$9=0,0,Master!$D$9)","v":0},{"$f":"IF(Master!$F$9=\"No\",IF(C7<18001,265,IF(C7<33501,440,IF(C7<54001,658,875))),0)","v":0},null,{"$f":"IF(Master!$F$8=0,0,Master!$F$8)","v":0},null,{"$f":"IF(Master!$F$13=0,0,Master!$F$13)","v":0},{"$nulls":5},{"$f":"SUM(K7:X7)","v":{"v":9119,"d":"9,119"}},{"$f":"J7-Y7","v":{"v":56256,"d":"56,256"}}]
[4,"2021-04-01",{"$f":"C7","v":{"v":52300,"d":"52,300"}},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C8=0,0,ROUND(C8*17%,0)))","v":{"v":8891,"d":"8,891"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.08*C8,0),ROUND(0.16*C8,0)))","v":{"v":4184,"d":"4,184"}},{"$f":"F7","v":0},{"$f":"G7","v":0},{"$f":"H7","v":0},null,{"v":65375,"d":"65,375"},{"$f":"K7","v":{"v":3000,"d":"3,000"}},{"$f":"L7","v":0},{"$f":"IF(Master!$F$9=\"YES\",ROUND((C8+D8)*0.1,0),0)","v":{"v":6119,"d":"6,119"}},{"$f":"N7","v":0},{"$f":"IF(Master!$F$9=\"No\",IF(C8<18001,265,IF(C8<33501,440,IF(C8<54001,658,875))),0)","v":0},null,{"$f":"Q7","v":0},{"$f":"IF(Master!D13=\"\",0,Master!D13)","v":220},{"$f":"S7","v":0},{"$nulls":4},{"$f":"X7","v":0},{"$f":"SUM(K8:X8)","v":{"v":9339,"d":"9,339"}},{"$f":"J8-Y8","v":{"v":56036,"d":"56,036"}}]
[5,"2021-05-01",{"$f":"C8","v":{"v":52300,"d":"52,300"}},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C9=0,0,ROUND(C9*17%,0)))","v":{"v":8891,"d":"8,891"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.08*C9,0),ROUND(0.16*C9,0)))","v":{"v":4184,"d":"4,184"}},{"$f":"F8","v":0},{"$f":"G8","v":0},{"$f":"H8","v":0},null,{"v":65375,"d":"65,375"},{"$f":"K8","v":{"v":3000,"d":"3,000"}},{"$f":"L8","v":0},{"$f":"IF(Master!$F$9=\"YES\",ROUND((C9+D9)*0.1,0),0)","v":{"v":6119,"d":"6,119"}},{"$f":"N8","v":0},{"$f":"IF(Master!$F$9=\"No\",IF(C9<18001,265,IF(C9<33501,440,IF(C9<54001,658,875))),0)","v":0},null,{"$f":"Q8","v":0},null,{"$f":"S8","v":0},{"$nulls":4},{"$f":"X8","v":0},{"v":9119,"d":"9,119"},{"v":56256,"d":"56,256"}]
[6,"2021-06-01",{"$f":"C9","v":{"v":52300,"d":"52,300"}},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C10=0,0,ROUND(C10*17%,0)))","v":{"v":8891,"d":"8,891"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.08*C10,0),ROUND(0.16*C10,0)))","v":{"v":4184,"d":"4,184"}},0,0,0,null,{"v":65375,"d":"65,375"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C10+D10)*0.1,0),0)","v":{"v":6119,"d":"6,119"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C10<18001,265,IF(C10<33501,440,IF(C10<54001,658,875))),0)","v":0},null,0,null,0,{"$nulls":4},0,{"v":9119,"d":"9,119"},{"v":56256,"d":"56,256"}]
[7,"2021-07-01",{"$f":"IF(Master!B5=\"Yes\",C10,MROUND(ROUND(1.03*C10,0),100))","v":{"v":53900,"d":"53,900"}},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C11=0,0,ROUND(C11*28%,0)))","v":{"v":15092,"d":"15,092"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.08*C11,0),ROUND(0.16*C11,0)))","v":{"v":4312,"d":"4,312"}},0,0,0,null,{"v":73304,"d":"73,304"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C11+D11)*0.1,0),0)","v":{"v":6899,"d":"6,899"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C11<18001,265,IF(C11<33501,440,IF(C11<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C11<18001,135,IF(C11<33501,220,IF(C11<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10229,"d":"10,229"},{"v":63075,"d":"63,075"}]
[8,"2021-08-01",{"$f":"C11","v":{"v":53900,"d":"53,900"}},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C12=0,0,ROUND(C12*28%,0)))","v":{"v":15092,"d":"15,092"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C12,0),ROUND(0.18*C12,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":73843,"d":"73,843"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C12+D12)*0.1,0),0)","v":{"v":6899,"d":"6,899"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C12<18001,265,IF(C12<33501,440,IF(C12<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C12<18001,135,IF(C12<33501,220,IF(C12<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10229,"d":"10,229"},{"v":63614,"d":"63,614"}]
[9,"2021-09-01",{"v":53900,"d":"53,900"},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C13=0,0,ROUND(C13*28%,0)))","v":{"v":15092,"d":"15,092"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C13,0),ROUND(0.18*C13,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":73843,"d":"73,843"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C13+D13)*0.1,0),0)","v":{"v":6899,"d":"6,899"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C13<18001,265,IF(C13<33501,440,IF(C13<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C13<18001,135,IF(C13<33501,220,IF(C13<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10229,"d":"10,229"},{"v":63614,"d":"63,614"}]
[10,"2021-10-01",{"v":53900,"d":"53,900"},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C14=0,0,ROUND(C14*31%,0)))","v":{"v":16709,"d":"16,709"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C14,0),ROUND(0.18*C14,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":75460,"d":"75,460"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C14+D14)*0.1,0),0)","v":{"v":7061,"d":"7,061"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C14<18001,265,IF(C14<33501,440,IF(C14<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C14<18001,135,IF(C14<33501,220,IF(C14<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10391,"d":"10,391"},{"v":65069,"d":"65,069"},null,null,{"$f":"$C$11*3%","v":1617},{"$f":"ROUND($AC$14*10%,0)","v":162},{"$f":"$AC$14-$AD$14","v":1455}]
[11,"2021-11-01",{"v":53900,"d":"53,900"},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C15=0,0,ROUND(C15*31%,0)))","v":{"v":16709,"d":"16,709"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C15,0),ROUND(0.18*C15,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":75460,"d":"75,460"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C15+D15)*0.1,0),0)","v":{"v":7061,"d":"7,061"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C15<18001,265,IF(C15<33501,440,IF(C15<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C15<18001,135,IF(C15<33501,220,IF(C15<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10391,"d":"10,391"},{"v":65069,"d":"65,069"},null,null,{"$f":"$C$12*3%","v":1617},{"$f":"ROUND($AC$14*10%,0)","v":162},{"$f":"$AC$15-$AD$15","v":1455}]
[12,"2021-12-01",{"v":53900,"d":"53,900"},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C16=0,0,ROUND(C16*31%,0)))","v":{"v":16709,"d":"16,709"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C16,0),ROUND(0.18*C16,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":75460,"d":"75,460"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C16+D16)*0.1,0),0)","v":{"v":7061,"d":"7,061"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C16<18001,265,IF(C16<33501,440,IF(C16<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C16<18001,135,IF(C16<33501,220,IF(C16<54001,330,440)))))","v":330},null,0,null,0,null,null,{"$f":"IF(Master!F4=\"State Service\",500,250)","v":500},null,0,{"v":10891,"d":"10,891"},{"v":64569,"d":"64,569"},null,null,{"$f":"$C$13*3%","v":1617},162,{"$f":"$AC$16-$AD$16","v":1455}]
[1,"2022-01-01",{"v":53900,"d":"53,900"},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C17=0,0,ROUND(C17*31%,0)))","v":{"v":16709,"d":"16,709"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C17,0),ROUND(0.18*C17,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":75460,"d":"75,460"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C17+D17)*0.1,0),0)","v":{"v":7061,"d":"7,061"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C17<18001,265,IF(C17<33501,440,IF(C17<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C17<18001,135,IF(C17<33501,220,IF(C17<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10391,"d":"10,391"},{"v":65069,"d":"65,069"}]
[2,"2022-02-01",{"v":53900,"d":"53,900"},{"$f":"IF(Master!$B$5=\"Yes\",0,IF(C18=0,0,ROUND(C18*31%,0)))","v":{"v":16709,"d":"16,709"}},{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(0.09*C18,0),ROUND(0.18*C18,0)))","v":{"v":4851,"d":"4,851"}},0,0,0,null,{"v":75460,"d":"75,460"},{"v":3000,"d":"3,000"},0,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C18+D18)*0.1,0),0)","v":{"v":7061,"d":"7,061"}},0,{"$f":"IF(Master!$F$9=\"No\",IF(C18<18001,265,IF(C18<33501,440,IF(C18<54001,658,875))),IF(Master!$B$13=\"NO\",0,IF(C18<18001,135,IF(C18<33501,220,IF(C18<54001,330,440)))))","v":330},null,0,null,0,{"$nulls":4},0,{"v":10391,"d":"10,391"},{"v":65069,"d":"65,069"},null,null,{"$f":"SUM($AC$14:$AC$16)","v":4851},{"$f":"SUM($AD$14:$AD$16)","v":486},{"$f":"SUM($AE$14:$AE$16)","v":4365}]
[null,"HRA Arrear July 2021",null,null,{"$f":"IF(Master!$B$8=\"NA\",0,IF(Master!$B$8=8%,ROUND(1%*C11,0),ROUND(2%*C11,0)))","v":539},{"$nulls":4},539,null,{"$f":"IF(IF(Master!$F$9=\"Yes\",0,IF(Master!$F$9=\"No\",$D$19,0))=0,0,IF(Master!$F$9=\"Yes\",0,IF(Master!$F$9=\"No\",$D$19,0)))","v":0},{"$nulls":12},0,539]
[null,"Bonus",{"$f":"IF(ROUND(IF(Master!$B$11=\"YES\",6774/12*Master!$D$11,0),0)=0,0,ROUND(IF(Master!$B$11=\"YES\",6774/12*Master!$D$11,0),0))","v":{"v":6774,"d":"6,774"}},{"$nulls":6},{"v":6774,"d":"6,774"},null,{"$f":"IF(IFERROR(IF(Master!$F$9=\"Yes\",0,IF(Master!$F$9=\"No\",ROUND($C$20*50%,0),0)),0)=0,0,IFERROR(IF(Master!$F$9=\"Yes\",0,IF(Master!$F$9=\"No\",ROUND($C$20*50%,0),0)),0))","v":0},{"$nulls":8},{"$f":"IFERROR(IF(IF(Master!$F$9=\"No\",0,ROUND($C$20*50%,0))=0,0,IF(Master!$F$9=\"No\",0,ROUND($C$20*50%,0))),0)","v":{"v":3387,"d":"3,387"}},{"$nulls":3},{"v":3387,"d":"3,387"},{"v":3387,"d":"3,387"}]
[null,"Surrender",{"$f":"IF(Master!B12=\"NO\",0,IF(Master!D12=\"NA\",0,IF(Master!D12=3,C18/2,VLOOKUP(Master!D12,$A$7:$C$18,3,FALSE)/2)))","v":0},{"$f":"IF(OR(Master!D12=1,Master!D12=2,Master!D12=10,Master!D12=11,Master!D12=12),ROUND(C21*31%,0),IF(AND(Master!D12>3,Master!D12<7),ROUND(C21*17%,0),ROUND(C21*28%,0)))","v":0},{"$nulls":5},0,{"$nulls":14},0,0]
[null,"DA Arrear",null,{"$f":"ROUND(C11*3%,0)*3","v":{"v":4851,"d":"4,851"}},{"$nulls":5},{"$f":"SUM(C22:I22)","v":{"v":4851,"d":"4,851"}},null,{"$f":"IF(Master!F9=\"NO\",ROUND(C11*3%,0)*3,0)","v":0},{"$f":"IF(Master!$F$9=\"YES\",AD18,0)","v":486},{"$nulls":7},{"$f":"IF(Master!F9=\"Yes\",D22-M22,0)","v":{"v":4365,"d":"4,365"}},{"$nulls":3},{"v":4851,"d":"4,851"},0]
[null,"Fixation Arrear",{"$nulls":7},0,null,null,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C23+D23)*0.1,0),0)","v":0},{"$nulls":11},0,0]
[null,"March Due Salary",{"$nulls":7},0,null,null,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C24+D24)*0.1,0),0)","v":0},{"$nulls":11},0,0]
[null,"Salary Arrear1",{"$nulls":7},0,null,null,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C25+D25)*0.1,0),0)","v":0},{"$nulls":11},0,0]
[null,"Salary Arrear2",{"$nulls":7},0,null,null,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C26+D26)*0.1,0),0)","v":0},{"$nulls":11},0,0]
[null,"Other",{"$nulls":7},0,null,null,{"$f":"IF(Master!$F$9=\"YES\",ROUND((C27+D27)*0.1,0),0)","v":0},{"$nulls":11},{"$f":"SUM(K27:X27)","v":0},{"$f":"J27-Y27","v":0}]
[null,"Total",{"$f":"SUM(C7:C27)","v":{"v":647174,"d":"647,174"}},{"$f":"SUM(D7:D27)","v":{"v":169236,"d":"169,236"}},{"v":55544,"d":"55,544"},0,0,0,0,{"v":871954,"d":"871,954"},{"v":36000,"d":"36,000"},0,{"v":80964,"d":"80,964"},0,{"v":2640,"d":"2,640"},0,0,220,0,0,{"v":7752,"d":"7,752"},500,0,0,{"v":128076,"d":"128,076"},{"v":743878,"d":"743,878"},0]
[]
[]
[null,"Signature Of Employee",{"$nulls":22},"Signature Of DDO"]

{"sheet":"Other Ded.","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"merged":[[0,0,0,6],[1,0,1,6],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
["Deductions other than Salry"]
[{"$f":"Master!B4&\", \"&Master!D4","v":"Ashwini Kumar Sharma, Lecturer"}]
[1,"मकान किराया भत्ता ( छूट जो लेनी है) YES/NO","NO",{"$f":"IF(C3=\"Yes\",'GA 55 For Print'!E28,0)","v":0},19," Defferred Annuty (स्थगित वार्षिकी)"]
[2,"गृह सम्पति से प्राप्त किराया - आय",null,null,20,"मनोरंजन भता धारा 16 (II) के अन्तर्गत ",{"$nulls":4},{"$f":"SUM(D19,G6)","v":0}]
[3,"गृहकर ",null,null,21,"व्यवयाय कर धारा 16 (III) के अन्तगर्त ",{"$nulls":4},{"$f":"SUM(G7,D19)","v":0}]
[4,"सरकारी पेंशन योजना में कर्मचारी का अंशदान अधिकतम वेतन का 10% धारा 80 CCD(1)",null,{"$f":"IF(J6>0,J6,0)","v":{"v":80964,"d":"80,964"}},22,"एफडी आदि अन्य जमा राशि पर प्राप्त कुल ब्याज (पीपीएफ को छोड़कर)",{"$nulls":3},{"$f":"IF(K6>L6,L6,K6)","v":80964},{"$f":"IF(Master!$F$9=\"No\",0,ROUND(10%*'GA 55 For Print'!$J$28,0))","v":87195},{"$f":"IF(Master!$F$9=\"No\",0,'GA 55 For Print'!$M$28)","v":80964}]
[5,"Covid - 19 (धारा 80G)",null,null,23,"अन्य विभिन्न स्त्रो़त्र (ब्याज के अलावा) से कुल आय",{"$nulls":4},{"$f":"SUM('Tax Calculaton Old'!F21:F30,'Tax Calculaton Old'!L21:L28)","v":{"v":124936,"d":"124936.00"}},{"$f":"IF(Master!$F$9=\"No\",50000,IF(M7>50000,50000,M7))","v":0},{"$f":"IF(K7>150000,K7-150000,0)","v":0}]
[6,"गृह ऋण किस्त मूल (जो वेतन से नहीं काटा गया)",null,null,24,"धारा 80 सी के अन्तर्गत अन्य मद में जमा करायी गयी राशि",{"$nulls":3},{"$f":"IF(Master!$F$11=\"No\",25000,50000)","v":25000}]
[7,"गृह ऋण किस्त ब्याज (जो वेतन से नहीं काटा गया)",null,null,25,"धारा 80 CCC पेंशन प्लान हेतु अंशदान (एन.पी.एस. के अलावा)"]
[8,"LIC जीवन बीमा प्रीमियम (जो वेतन से नही काटा गया)",null,null,26,"धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)",0,null,null,{"$f":"IF(Master!$F$11=\"No\",40000,100000)","v":40000}]
[9,"PLI (पी.एल.आई.)",null,null,27,"धारा 80D चिकित्सा बीमा प्रीमियम (सामान्य 25000, वरिष्ठ नागरिक 50000)",{"$f":"IF(Master!F9=\"Yes\",SUM('GA 55 For Print'!O11:O18),SUM('GA 55 For Print'!O11:O18))","v":{"v":2640,"d":"2,640"}},null,null,{"$f":"SUM('GA 55 For Print'!C7:C18,'GA 55 For Print'!D7:D18)","v":{"v":804785,"d":"804,785"}}]
[10,"टयूशन फीस",null,null,28,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार(अधिकतम 75000, 80% विकलांगता 125000)",{"$nulls":3},{"$f":"'GA 55 For Print'!E28","v":{"v":55544,"d":"55,544"}}]
[11,"PPF (लोक भविष्य निधि)",null,null,29,"धारा 80DDB विशिष्ट रोगों के उपचार हेतु कटौती (सामान्य 40000, वरिष्ठ नागरिक 1 लाख)"]
[12,"सुकन्या समृद्धि योजना",null,null,30,"धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज"]
[13,"यू. एल. आई. पी./वार्षिक प्लान",null,null,31,"धारा 80U स्थाई शारीरिक विकलांगता (अधिकतम 75000ए 80% विकलांगता 125000)"]
[14,"NSS (राष्ट्रीय बचत स्कीम)",null,null,32,"धारा 80GGA अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास हेतु दिया गया दान"]
[15,"NSC (राष्ट्रीय बचत पत्र)",null,null,33,"राहत धारा 89 के अन्तर्गत"]
[16,"राष्ट्रीय बचत पत्र पर ब्याज",null,null,34,"वेतन बिल के अलावा जमा कराया गया आयकर (TDS)"]
[17,"बचत खाते की जमा राशि पर प्राप्त ब्याज",null,null,35,"धारा 10(14) के अन्तर्गत भत्ते जो करमुक्त है"]
[18,"इक्विटी लिंक सेविंग स्कीम",null,null,36,"धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी 100% एवं ख श्रेणी 50%)"]

{"sheet":"Summary","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[0,0,0,4],[2,1,2,4],[7,0,7,1],[7,2,7,4],[8,0,8,1],[8,2,8,4],[9,0,9,1],[9,2,9,4],[10,0,10,1],[10,2,10,4]]}
[{"$f":"Master!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
[]
["Name Of Employee",{"$f":"Master!B4","v":"Ashwini Kumar Sharma"}]
[]
["Gross Pay","Taxable Amt","Tax Deposit","Rebate Under Section 80C, 80CCC, 80CCD(1)","मकान किराया छूट के लिए रसीद की आवश्यकता"]
[{"$f":"'Tax Calculaton Old'!$M$4","v":{"v":952918,"d":"952918.00"}},{"$f":"'Tax Calculaton Old'!M48","v":{"v":694380,"d":"694380.00"}},{"$f":"'Tax Calculaton Old'!M63","v":{"v":0,"d":"0.00"}},{"$f":"'Tax Calculaton Old'!M31","v":{"v":124936,"d":"124936.00"}},{"$f":"IF('Other Ded.'!D3=0,0,ROUND(0.1*'Other Ded.'!J11,0)+'Other Ded.'!D3)","v":{"v":0,"d":"0.00"}}]
[]
["TAX Position (Old Tax Scheme)",null,{"$f":"'Tax Calculaton Old'!A64&\" = \"&'Tax Calculaton Old'!M64","v":"Income Tax Payable = 53431"}]
["TAX Position (New Tax Scheme)",null,{"$f":"'Tax Calculaton New'!A56&\" = \"&'Tax Calculaton New'!M56","v":"Income Tax Payable = 58025"}]
["Total Rebate Under Section 80C, 80CCC, 80CCD(1)",null,{"$f":"'Tax Calculaton Old'!M31","v":{"v":124936,"d":"124936.00"}}]
["Investable Amount",null,{"$f":"150000-C10","v":{"v":25064,"d":"25064.00"}}]

{"sheet":"GA 55 For Print","index":5,"n_rows":31,"n_cols":27,"rows_kept":31,"merged":[[0,1,0,26],[1,1,1,26],[3,2,3,5],[3,7,3,9],[3,11,3,12],[3,13,3,14],[3,15,3,18],[3,19,3,21],[3,22,3,23],[3,25,3,26],[4,2,4,5],[4,7,4,9],[4,11,4,12],[4,13,4,14],[4,15,4,18],[4,19,4,21],[4,22,4,25],[30,1,30,3],[30,24,30,25]]}
[null,{"$f":"Master!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
[null,"Salary and Deduction Detail for FY : 2021-22"]
[]
[null,"नाम कर्मचारी-",{"$f":"IF('GA 55 Editable'!C4=\"\",\"\",'GA 55 Editable'!C4)","v":"Ashwini Kumar Sharma"},{"$nulls":3},"पद-",{"$f":"IF('GA 55 Editable'!H4=\"\",\"\",'GA 55 Editable'!H4)","v":"Lecturer"},null,null,"लेवल-",{"$f":"IF('GA 55 Editable'!L4=\"\",\"\",'GA 55 Editable'!L4)","v":"L-12"},null,"Employee ID-",null,{"$f":"IF('GA 55 Editable'!P4=\"\",\"\",'GA 55 Editable'!P4)","v":"RJNA201228008021"},{"$nulls":3},"मार्च का बेसिक-",null,null,{"$f":"IF('GA 55 Editable'!W4=\"\",\"\",'GA 55 Editable'!W4)","v":{"v":52300,"d":"52300.00"}},null,"TAN No.",{"$f":"IF('GA 55 Editable'!Z4=\"\",\"\",'GA 55 Editable'!Z4)","v":"ABCD1234E"}]
[null,"पैन नं.-",{"$f":"IF('GA 55 Editable'!C5=\"\",\"\",'GA 55 Editable'!C5:F5)","v":"AAAA9456A"},{"$nulls":3},"Mobile-",{"$f":"IF('GA 55 Editable'!H5=\"\",\"\",'GA 55 Editable'!H5)","v":9166023711},null,null,"SI No.-",{"$f":"IF('GA 55 Editable'!L5=\"\",\"\",'GA 55 Editable'!L5)","v":123456},null,"GPF/PRAN No.-",null,{"$f":"IF('GA 55 Editable'!P5=\"\",\"\",'GA 55 Editable'!P5)","v":"1234567891011"},{"$nulls":3},"बैंक खाता सं.-",null,null,{"$f":"IF('GA 55 Editable'!W5=\"\",\"\",'GA 55 Editable'!W5)","v":"123456789101112"}]
[null,"Month & Year","Basic Pay","DA","HRA","Washing Allow.","Handicaped Allowance","CCA Allowance","Other Allowance","Gross Salary","SIP","GPF","NPS","GPF Loan","RPMF","SI Arrear","SI Loan","GIS","LIC","COVIS-19","GPF 2004","Hitkari Nidhi","Other","ITAX","Total Deduction","NET Payment","Bill No./ Dte"]
[3,"2021-03-01",{"$f":"IF('GA 55 Editable'!C7=\"\",\"\",'GA 55 Editable'!C7)","v":{"v":52300,"d":"52,300"}},{"$f":"IF('GA 55 Editable'!D7=\"\",\"\",'GA 55 Editable'!D7)","v":{"v":8891,"d":"8,891"}},{"$f":"IF('GA 55 Editable'!E7=\"\",\"\",'GA 55 Editable'!E7)","v":{"v":4184,"d":"4,184"}},{"$f":"IF('GA 55 Editable'!F7=\"\",\"\",'GA 55 Editable'!F7)","v":0},{"$f":"IF('GA 55 Editable'!G7=\"\",\"\",'GA 55 Editable'!G7)","v":0},{"$f":"IF('GA 55 Editable'!H7=\"\",\"\",'GA 55 Editable'!H7)","v":0},{"$f":"IF('GA 55 Editable'!I7=\"\",\"\",'GA 55 Editable'!I7)","v":""},{"$f":"IF('GA 55 Editable'!J7=\"\",\"\",'GA 55 Editable'!J7)","v":{"v":65375,"d":"65,375"}},{"$f":"IF('GA 55 Editable'!K7=\"\",\"\",'GA 55 Editable'!K7)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L7=\"\",\"\",'GA 55 Editable'!L7)","v":0},{"$f":"IF('GA 55 Editable'!M7=\"\",\"\",'GA 55 Editable'!M7)","v":{"v":6119,"d":"6,119"}},{"$f":"IF('GA 55 Editable'!N7=\"\",\"\",'GA 55 Editable'!N7)","v":0},{"$f":"IF('GA 55 Editable'!O7=\"\",\"\",'GA 55 Editable'!O7)","v":0},{"$f":"IF('GA 55 Editable'!P7=\"\",\"\",'GA 55 Editable'!P7)","v":""},{"$f":"IF('GA 55 Editable'!Q7=\"\",\"\",'GA 55 Editable'!Q7)","v":0},{"$f":"IF('GA 55 Editable'!R7=\"\",\"\",'GA 55 Editable'!R7)","v":""},{"$f":"IF('GA 55 Editable'!S7=\"\",\"\",'GA 55 Editable'!S7)","v":0},{"$f":"IF('GA 55 Editable'!T7=\"\",\"\",'GA 55 Editable'!T7)","v":""},{"$f":"IF('GA 55 Editable'!U7=\"\",\"\",'GA 55 Editable'!U7)","v":""},{"$f":"IF('GA 55 Editable'!V7=\"\",\"\",'GA 55 Editable'!V7)","v":""},{"$f":"IF('GA 55 Editable'!W7=\"\",\"\",'GA 55 Editable'!W7)","v":""},{"$f":"IF('GA 55 Editable'!X7=\"\",\"\",'GA 55 Editable'!X7)","v":""},{"$f":"IF('GA 55 Editable'!Y7=\"\",\"\",'GA 55 Editable'!Y7)","v":{"v":9119,"d":"9,119"}},{"$f":"IF('GA 55 Editable'!Z7=\"\",\"\",'GA 55 Editable'!Z7)","v":{"v":56256,"d":"56,256"}},{"$f":"IF('GA 55 Editable'!AA7=\"\",\"\",'GA 55 Editable'!AA7)","v":""}]
[4,"2021-04-01",{"$f":"IF('GA 55 Editable'!C8=\"\",\"\",'GA 55 Editable'!C8)","v":{"v":52300,"d":"52,300"}},{"$f":"IF('GA 55 Editable'!D8=\"\",\"\",'GA 55 Editable'!D8)","v":{"v":8891,"d":"8,891"}},{"$f":"IF('GA 55 Editable'!E8=\"\",\"\",'GA 55 Editable'!E8)","v":{"v":4184,"d":"4,184"}},{"$f":"IF('GA 55 Editable'!F8=\"\",\"\",'GA 55 Editable'!F8)","v":0},{"$f":"IF('GA 55 Editable'!G8=\"\",\"\",'GA 55 Editable'!G8)","v":0},{"$f":"IF('GA 55 Editable'!H8=\"\",\"\",'GA 55 Editable'!H8)","v":0},{"$f":"IF('GA 55 Editable'!I8=\"\",\"\",'GA 55 Editable'!I8)","v":""},{"$f":"IF('GA 55 Editable'!J8=\"\",\"\",'GA 55 Editable'!J8)","v":{"v":65375,"d":"65,375"}},{"$f":"IF('GA 55 Editable'!K8=\"\",\"\",'GA 55 Editable'!K8)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L8=\"\",\"\",'GA 55 Editable'!L8)","v":0},{"$f":"IF('GA 55 Editable'!M8=\"\",\"\",'GA 55 Editable'!M8)","v":{"v":6119,"d":"6,119"}},{"$f":"IF('GA 55 Editable'!N8=\"\",\"\",'GA 55 Editable'!N8)","v":0},{"$f":"IF('GA 55 Editable'!O8=\"\",\"\",'GA 55 Editable'!O8)","v":0},{"$f":"IF('GA 55 Editable'!P8=\"\",\"\",'GA 55 Editable'!P8)","v":""},{"$f":"IF('GA 55 Editable'!Q8=\"\",\"\",'GA 55 Editable'!Q8)","v":0},{"$f":"IF('GA 55 Editable'!R8=\"\",\"\",'GA 55 Editable'!R8)","v":220},{"$f":"IF('GA 55 Editable'!S8=\"\",\"\",'GA 55 Editable'!S8)","v":0},{"$f":"IF('GA 55 Editable'!T8=\"\",\"\",'GA 55 Editable'!T8)","v":""},{"$f":"IF('GA 55 Editable'!U8=\"\",\"\",'GA 55 Editable'!U8)","v":""},{"$f":"IF('GA 55 Editable'!V8=\"\",\"\",'GA 55 Editable'!V8)","v":""},{"$f":"IF('GA 55 Editable'!W8=\"\",\"\",'GA 55 Editable'!W8)","v":""},{"$f":"IF('GA 55 Editable'!X8=\"\",\"\",'GA 55 Editable'!X8)","v":0},{"$f":"IF('GA 55 Editable'!Y8=\"\",\"\",'GA 55 Editable'!Y8)","v":{"v":9339,"d":"9,339"}},{"$f":"IF('GA 55 Editable'!Z8=\"\",\"\",'GA 55 Editable'!Z8)","v":{"v":56036,"d":"56,036"}},{"$f":"IF('GA 55 Editable'!AA8=\"\",\"\",'GA 55 Editable'!AA8)","v":""}]
[5,"2021-05-01",{"$f":"IF('GA 55 Editable'!C9=\"\",\"\",'GA 55 Editable'!C9)","v":{"v":52300,"d":"52,300"}},{"$f":"IF('GA 55 Editable'!D9=\"\",\"\",'GA 55 Editable'!D9)","v":{"v":8891,"d":"8,891"}},{"$f":"IF('GA 55 Editable'!E9=\"\",\"\",'GA 55 Editable'!E9)","v":{"v":4184,"d":"4,184"}},{"$f":"IF('GA 55 Editable'!F9=\"\",\"\",'GA 55 Editable'!F9)","v":0},{"$f":"IF('GA 55 Editable'!G9=\"\",\"\",'GA 55 Editable'!G9)","v":0},{"$f":"IF('GA 55 Editable'!H9=\"\",\"\",'GA 55 Editable'!H9)","v":0},{"$f":"IF('GA 55 Editable'!I9=\"\",\"\",'GA 55 Editable'!I9)","v":""},{"$f":"IF('GA 55 Editable'!J9=\"\",\"\",'GA 55 Editable'!J9)","v":{"v":65375,"d":"65,375"}},{"$f":"IF('GA 55 Editable'!K9=\"\",\"\",'GA 55 Editable'!K9)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L9=\"\",\"\",'GA 55 Editable'!L9)","v":0},{"$f":"IF('GA 55 Editable'!M9=\"\",\"\",'GA 55 Editable'!M9)","v":{"v":6119,"d":"6,119"}},{"$f":"IF('GA 55 Editable'!N9=\"\",\"\",'GA 55 Editable'!N9)","v":0},{"$f":"IF('GA 55 Editable'!O9=\"\",\"\",'GA 55 Editable'!O9)","v":0},{"$f":"IF('GA 55 Editable'!P9=\"\",\"\",'GA 55 Editable'!P9)","v":""},{"$f":"IF('GA 55 Editable'!Q9=\"\",\"\",'GA 55 Editable'!Q9)","v":0},{"$f":"IF('GA 55 Editable'!R9=\"\",\"\",'GA 55 Editable'!R9)","v":""},{"$f":"IF('GA 55 Editable'!S9=\"\",\"\",'GA 55 Editable'!S9)","v":0},{"$f":"IF('GA 55 Editable'!T9=\"\",\"\",'GA 55 Editable'!T9)","v":""},{"$f":"IF('GA 55 Editable'!U9=\"\",\"\",'GA 55 Editable'!U9)","v":""},{"$f":"IF('GA 55 Editable'!V9=\"\",\"\",'GA 55 Editable'!V9)","v":""},{"$f":"IF('GA 55 Editable'!W9=\"\",\"\",'GA 55 Editable'!W9)","v":""},{"$f":"IF('GA 55 Editable'!X9=\"\",\"\",'GA 55 Editable'!X9)","v":0},{"$f":"IF('GA 55 Editable'!Y9=\"\",\"\",'GA 55 Editable'!Y9)","v":{"v":9119,"d":"9,119"}},{"$f":"IF('GA 55 Editable'!Z9=\"\",\"\",'GA 55 Editable'!Z9)","v":{"v":56256,"d":"56,256"}},{"$f":"IF('GA 55 Editable'!AA9=\"\",\"\",'GA 55 Editable'!AA9)","v":""}]
[6,"2021-06-01",{"$f":"IF('GA 55 Editable'!C10=\"\",\"\",'GA 55 Editable'!C10)","v":{"v":52300,"d":"52,300"}},{"$f":"IF('GA 55 Editable'!D10=\"\",\"\",'GA 55 Editable'!D10)","v":{"v":8891,"d":"8,891"}},{"$f":"IF('GA 55 Editable'!E10=\"\",\"\",'GA 55 Editable'!E10)","v":{"v":4184,"d":"4,184"}},{"$f":"IF('GA 55 Editable'!F10=\"\",\"\",'GA 55 Editable'!F10)","v":0},{"$f":"IF('GA 55 Editable'!G10=\"\",\"\",'GA 55 Editable'!G10)","v":0},{"$f":"IF('GA 55 Editable'!H10=\"\",\"\",'GA 55 Editable'!H10)","v":0},{"$f":"IF('GA 55 Editable'!I10=\"\",\"\",'GA 55 Editable'!I10)","v":""},{"$f":"IF('GA 55 Editable'!J10=\"\",\"\",'GA 55 Editable'!J10)","v":{"v":65375,"d":"65,375"}},{"$f":"IF('GA 55 Editable'!K10=\"\",\"\",'GA 55 Editable'!K10)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L10=\"\",\"\",'GA 55 Editable'!L10)","v":0},{"$f":"IF('GA 55 Editable'!M10=\"\",\"\",'GA 55 Editable'!M10)","v":{"v":6119,"d":"6,119"}},{"$f":"IF('GA 55 Editable'!N10=\"\",\"\",'GA 55 Editable'!N10)","v":0},{"$f":"IF('GA 55 Editable'!O10=\"\",\"\",'GA 55 Editable'!O10)","v":0},{"$f":"IF('GA 55 Editable'!P10=\"\",\"\",'GA 55 Editable'!P10)","v":""},{"$f":"IF('GA 55 Editable'!Q10=\"\",\"\",'GA 55 Editable'!Q10)","v":0},{"$f":"IF('GA 55 Editable'!R10=\"\",\"\",'GA 55 Editable'!R10)","v":""},{"$f":"IF('GA 55 Editable'!S10=\"\",\"\",'GA 55 Editable'!S10)","v":0},{"$f":"IF('GA 55 Editable'!T10=\"\",\"\",'GA 55 Editable'!T10)","v":""},{"$f":"IF('GA 55 Editable'!U10=\"\",\"\",'GA 55 Editable'!U10)","v":""},{"$f":"IF('GA 55 Editable'!V10=\"\",\"\",'GA 55 Editable'!V10)","v":""},{"$f":"IF('GA 55 Editable'!W10=\"\",\"\",'GA 55 Editable'!W10)","v":""},{"$f":"IF('GA 55 Editable'!X10=\"\",\"\",'GA 55 Editable'!X10)","v":0},{"$f":"IF('GA 55 Editable'!Y10=\"\",\"\",'GA 55 Editable'!Y10)","v":{"v":9119,"d":"9,119"}},{"$f":"IF('GA 55 Editable'!Z10=\"\",\"\",'GA 55 Editable'!Z10)","v":{"v":56256,"d":"56,256"}},{"$f":"IF('GA 55 Editable'!AA10=\"\",\"\",'GA 55 Editable'!AA10)","v":""}]
[7,"2021-07-01",{"$f":"IF('GA 55 Editable'!C11=\"\",\"\",'GA 55 Editable'!C11)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D11=\"\",\"\",'GA 55 Editable'!D11)","v":{"v":15092,"d":"15,092"}},{"$f":"IF('GA 55 Editable'!E11=\"\",\"\",'GA 55 Editable'!E11)","v":{"v":4312,"d":"4,312"}},{"$f":"IF('GA 55 Editable'!F11=\"\",\"\",'GA 55 Editable'!F11)","v":0},{"$f":"IF('GA 55 Editable'!G11=\"\",\"\",'GA 55 Editable'!G11)","v":0},{"$f":"IF('GA 55 Editable'!H11=\"\",\"\",'GA 55 Editable'!H11)","v":0},{"$f":"IF('GA 55 Editable'!I11=\"\",\"\",'GA 55 Editable'!I11)","v":""},{"$f":"IF('GA 55 Editable'!J11=\"\",\"\",'GA 55 Editable'!J11)","v":{"v":73304,"d":"73,304"}},{"$f":"IF('GA 55 Editable'!K11=\"\",\"\",'GA 55 Editable'!K11)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L11=\"\",\"\",'GA 55 Editable'!L11)","v":0},{"$f":"IF('GA 55 Editable'!M11=\"\",\"\",'GA 55 Editable'!M11)","v":{"v":6899,"d":"6,899"}},{"$f":"IF('GA 55 Editable'!N11=\"\",\"\",'GA 55 Editable'!N11)","v":0},{"$f":"IF('GA 55 Editable'!O11=\"\",\"\",'GA 55 Editable'!O11)","v":330},{"$f":"IF('GA 55 Editable'!P11=\"\",\"\",'GA 55 Editable'!P11)","v":""},{"$f":"IF('GA 55 Editable'!Q11=\"\",\"\",'GA 55 Editable'!Q11)","v":0},{"$f":"IF('GA 55 Editable'!R11=\"\",\"\",'GA 55 Editable'!R11)","v":""},{"$f":"IF('GA 55 Editable'!S11=\"\",\"\",'GA 55 Editable'!S11)","v":0},{"$f":"IF('GA 55 Editable'!T11=\"\",\"\",'GA 55 Editable'!T11)","v":""},{"$f":"IF('GA 55 Editable'!U11=\"\",\"\",'GA 55 Editable'!U11)","v":""},{"$f":"IF('GA 55 Editable'!V11=\"\",\"\",'GA 55 Editable'!V11)","v":""},{"$f":"IF('GA 55 Editable'!W11=\"\",\"\",'GA 55 Editable'!W11)","v":""},{"$f":"IF('GA 55 Editable'!X11=\"\",\"\",'GA 55 Editable'!X11)","v":0},{"$f":"IF('GA 55 Editable'!Y11=\"\",\"\",'GA 55 Editable'!Y11)","v":{"v":10229,"d":"10,229"}},{"$f":"IF('GA 55 Editable'!Z11=\"\",\"\",'GA 55 Editable'!Z11)","v":{"v":63075,"d":"63,075"}},{"$f":"IF('GA 55 Editable'!AA11=\"\",\"\",'GA 55 Editable'!AA11)","v":""}]
[8,"2021-08-01",{"$f":"IF('GA 55 Editable'!C12=\"\",\"\",'GA 55 Editable'!C12)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D12=\"\",\"\",'GA 55 Editable'!D12)","v":{"v":15092,"d":"15,092"}},{"$f":"IF('GA 55 Editable'!E12=\"\",\"\",'GA 55 Editable'!E12)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F12=\"\",\"\",'GA 55 Editable'!F12)","v":0},{"$f":"IF('GA 55 Editable'!G12=\"\",\"\",'GA 55 Editable'!G12)","v":0},{"$f":"IF('GA 55 Editable'!H12=\"\",\"\",'GA 55 Editable'!H12)","v":0},{"$f":"IF('GA 55 Editable'!I12=\"\",\"\",'GA 55 Editable'!I12)","v":""},{"$f":"IF('GA 55 Editable'!J12=\"\",\"\",'GA 55 Editable'!J12)","v":{"v":73843,"d":"73,843"}},{"$f":"IF('GA 55 Editable'!K12=\"\",\"\",'GA 55 Editable'!K12)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L12=\"\",\"\",'GA 55 Editable'!L12)","v":0},{"$f":"IF('GA 55 Editable'!M12=\"\",\"\",'GA 55 Editable'!M12)","v":{"v":6899,"d":"6,899"}},{"$f":"IF('GA 55 Editable'!N12=\"\",\"\",'GA 55 Editable'!N12)","v":0},{"$f":"IF('GA 55 Editable'!O12=\"\",\"\",'GA 55 Editable'!O12)","v":330},{"$f":"IF('GA 55 Editable'!P12=\"\",\"\",'GA 55 Editable'!P12)","v":""},{"$f":"IF('GA 55 Editable'!Q12=\"\",\"\",'GA 55 Editable'!Q12)","v":0},{"$f":"IF('GA 55 Editable'!R12=\"\",\"\",'GA 55 Editable'!R12)","v":""},{"$f":"IF('GA 55 Editable'!S12=\"\",\"\",'GA 55 Editable'!S12)","v":0},{"$f":"IF('GA 55 Editable'!T12=\"\",\"\",'GA 55 Editable'!T12)","v":""},{"$f":"IF('GA 55 Editable'!U12=\"\",\"\",'GA 55 Editable'!U12)","v":""},{"$f":"IF('GA 55 Editable'!V12=\"\",\"\",'GA 55 Editable'!V12)","v":""},{"$f":"IF('GA 55 Editable'!W12=\"\",\"\",'GA 55 Editable'!W12)","v":""},{"$f":"IF('GA 55 Editable'!X12=\"\",\"\",'GA 55 Editable'!X12)","v":0},{"$f":"IF('GA 55 Editable'!Y12=\"\",\"\",'GA 55 Editable'!Y12)","v":{"v":10229,"d":"10,229"}},{"$f":"IF('GA 55 Editable'!Z12=\"\",\"\",'GA 55 Editable'!Z12)","v":{"v":63614,"d":"63,614"}},{"$f":"IF('GA 55 Editable'!AA12=\"\",\"\",'GA 55 Editable'!AA12)","v":""}]
[9,"2021-09-01",{"$f":"IF('GA 55 Editable'!C13=\"\",\"\",'GA 55 Editable'!C13)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D13=\"\",\"\",'GA 55 Editable'!D13)","v":{"v":15092,"d":"15,092"}},{"$f":"IF('GA 55 Editable'!E13=\"\",\"\",'GA 55 Editable'!E13)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F13=\"\",\"\",'GA 55 Editable'!F13)","v":0},{"$f":"IF('GA 55 Editable'!G13=\"\",\"\",'GA 55 Editable'!G13)","v":0},{"$f":"IF('GA 55 Editable'!H13=\"\",\"\",'GA 55 Editable'!H13)","v":0},{"$f":"IF('GA 55 Editable'!I13=\"\",\"\",'GA 55 Editable'!I13)","v":""},{"$f":"IF('GA 55 Editable'!J13=\"\",\"\",'GA 55 Editable'!J13)","v":{"v":73843,"d":"73,843"}},{"$f":"IF('GA 55 Editable'!K13=\"\",\"\",'GA 55 Editable'!K13)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L13=\"\",\"\",'GA 55 Editable'!L13)","v":0},{"$f":"IF('GA 55 Editable'!M13=\"\",\"\",'GA 55 Editable'!M13)","v":{"v":6899,"d":"6,899"}},{"$f":"IF('GA 55 Editable'!N13=\"\",\"\",'GA 55 Editable'!N13)","v":0},{"$f":"IF('GA 55 Editable'!O13=\"\",\"\",'GA 55 Editable'!O13)","v":330},{"$f":"IF('GA 55 Editable'!P13=\"\",\"\",'GA 55 Editable'!P13)","v":""},{"$f":"IF('GA 55 Editable'!Q13=\"\",\"\",'GA 55 Editable'!Q13)","v":0},{"$f":"IF('GA 55 Editable'!R13=\"\",\"\",'GA 55 Editable'!R13)","v":""},{"$f":"IF('GA 55 Editable'!S13=\"\",\"\",'GA 55 Editable'!S13)","v":0},{"$f":"IF('GA 55 Editable'!T13=\"\",\"\",'GA 55 Editable'!T13)","v":""},{"$f":"IF('GA 55 Editable'!U13=\"\",\"\",'GA 55 Editable'!U13)","v":""},{"$f":"IF('GA 55 Editable'!V13=\"\",\"\",'GA 55 Editable'!V13)","v":""},{"$f":"IF('GA 55 Editable'!W13=\"\",\"\",'GA 55 Editable'!W13)","v":""},{"$f":"IF('GA 55 Editable'!X13=\"\",\"\",'GA 55 Editable'!X13)","v":0},{"$f":"IF('GA 55 Editable'!Y13=\"\",\"\",'GA 55 Editable'!Y13)","v":{"v":10229,"d":"10,229"}},{"$f":"IF('GA 55 Editable'!Z13=\"\",\"\",'GA 55 Editable'!Z13)","v":{"v":63614,"d":"63,614"}},{"$f":"IF('GA 55 Editable'!AA13=\"\",\"\",'GA 55 Editable'!AA13)","v":""}]
[10,"2021-10-01",{"$f":"IF('GA 55 Editable'!C14=\"\",\"\",'GA 55 Editable'!C14)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D14=\"\",\"\",'GA 55 Editable'!D14)","v":{"v":16709,"d":"16,709"}},{"$f":"IF('GA 55 Editable'!E14=\"\",\"\",'GA 55 Editable'!E14)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F14=\"\",\"\",'GA 55 Editable'!F14)","v":0},{"$f":"IF('GA 55 Editable'!G14=\"\",\"\",'GA 55 Editable'!G14)","v":0},{"$f":"IF('GA 55 Editable'!H14=\"\",\"\",'GA 55 Editable'!H14)","v":0},{"$f":"IF('GA 55 Editable'!I14=\"\",\"\",'GA 55 Editable'!I14)","v":""},{"$f":"IF('GA 55 Editable'!J14=\"\",\"\",'GA 55 Editable'!J14)","v":{"v":75460,"d":"75,460"}},{"$f":"IF('GA 55 Editable'!K14=\"\",\"\",'GA 55 Editable'!K14)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L14=\"\",\"\",'GA 55 Editable'!L14)","v":0},{"$f":"IF('GA 55 Editable'!M14=\"\",\"\",'GA 55 Editable'!M14)","v":{"v":7061,"d":"7,061"}},{"$f":"IF('GA 55 Editable'!N14=\"\",\"\",'GA 55 Editable'!N14)","v":0},{"$f":"IF('GA 55 Editable'!O14=\"\",\"\",'GA 55 Editable'!O14)","v":330},{"$f":"IF('GA 55 Editable'!P14=\"\",\"\",'GA 55 Editable'!P14)","v":""},{"$f":"IF('GA 55 Editable'!Q14=\"\",\"\",'GA 55 Editable'!Q14)","v":0},{"$f":"IF('GA 55 Editable'!R14=\"\",\"\",'GA 55 Editable'!R14)","v":""},{"$f":"IF('GA 55 Editable'!S14=\"\",\"\",'GA 55 Editable'!S14)","v":0},{"$f":"IF('GA 55 Editable'!T14=\"\",\"\",'GA 55 Editable'!T14)","v":""},{"$f":"IF('GA 55 Editable'!U14=\"\",\"\",'GA 55 Editable'!U14)","v":""},{"$f":"IF('GA 55 Editable'!V14=\"\",\"\",'GA 55 Editable'!V14)","v":""},{"$f":"IF('GA 55 Editable'!W14=\"\",\"\",'GA 55 Editable'!W14)","v":""},{"$f":"IF('GA 55 Editable'!X14=\"\",\"\",'GA 55 Editable'!X14)","v":0},{"$f":"IF('GA 55 Editable'!Y14=\"\",\"\",'GA 55 Editable'!Y14)","v":{"v":10391,"d":"10,391"}},{"$f":"IF('GA 55 Editable'!Z14=\"\",\"\",'GA 55 Editable'!Z14)","v":{"v":65069,"d":"65,069"}},{"$f":"IF('GA 55 Editable'!AA14=\"\",\"\",'GA 55 Editable'!AA14)","v":""}]
[11,"2021-11-01",{"$f":"IF('GA 55 Editable'!C15=\"\",\"\",'GA 55 Editable'!C15)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D15=\"\",\"\",'GA 55 Editable'!D15)","v":{"v":16709,"d":"16,709"}},{"$f":"IF('GA 55 Editable'!E15=\"\",\"\",'GA 55 Editable'!E15)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F15=\"\",\"\",'GA 55 Editable'!F15)","v":0},{"$f":"IF('GA 55 Editable'!G15=\"\",\"\",'GA 55 Editable'!G15)","v":0},{"$f":"IF('GA 55 Editable'!H15=\"\",\"\",'GA 55 Editable'!H15)","v":0},{"$f":"IF('GA 55 Editable'!I15=\"\",\"\",'GA 55 Editable'!I15)","v":""},{"$f":"IF('GA 55 Editable'!J15=\"\",\"\",'GA 55 Editable'!J15)","v":{"v":75460,"d":"75,460"}},{"$f":"IF('GA 55 Editable'!K15=\"\",\"\",'GA 55 Editable'!K15)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L15=\"\",\"\",'GA 55 Editable'!L15)","v":0},{"$f":"IF('GA 55 Editable'!M15=\"\",\"\",'GA 55 Editable'!M15)","v":{"v":7061,"d":"7,061"}},{"$f":"IF('GA 55 Editable'!N15=\"\",\"\",'GA 55 Editable'!N15)","v":0},{"$f":"IF('GA 55 Editable'!O15=\"\",\"\",'GA 55 Editable'!O15)","v":330},{"$f":"IF('GA 55 Editable'!P15=\"\",\"\",'GA 55 Editable'!P15)","v":""},{"$f":"IF('GA 55 Editable'!Q15=\"\",\"\",'GA 55 Editable'!Q15)","v":0},{"$f":"IF('GA 55 Editable'!R15=\"\",\"\",'GA 55 Editable'!R15)","v":""},{"$f":"IF('GA 55 Editable'!S15=\"\",\"\",'GA 55 Editable'!S15)","v":0},{"$f":"IF('GA 55 Editable'!T15=\"\",\"\",'GA 55 Editable'!T15)","v":""},{"$f":"IF('GA 55 Editable'!U15=\"\",\"\",'GA 55 Editable'!U15)","v":""},{"$f":"IF('GA 55 Editable'!V15=\"\",\"\",'GA 55 Editable'!V15)","v":""},{"$f":"IF('GA 55 Editable'!W15=\"\",\"\",'GA 55 Editable'!W15)","v":""},{"$f":"IF('GA 55 Editable'!X15=\"\",\"\",'GA 55 Editable'!X15)","v":0},{"$f":"IF('GA 55 Editable'!Y15=\"\",\"\",'GA 55 Editable'!Y15)","v":{"v":10391,"d":"10,391"}},{"$f":"IF('GA 55 Editable'!Z15=\"\",\"\",'GA 55 Editable'!Z15)","v":{"v":65069,"d":"65,069"}},{"$f":"IF('GA 55 Editable'!AA15=\"\",\"\",'GA 55 Editable'!AA15)","v":""}]
[12,"2021-12-01",{"$f":"IF('GA 55 Editable'!C16=\"\",\"\",'GA 55 Editable'!C16)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D16=\"\",\"\",'GA 55 Editable'!D16)","v":{"v":16709,"d":"16,709"}},{"$f":"IF('GA 55 Editable'!E16=\"\",\"\",'GA 55 Editable'!E16)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F16=\"\",\"\",'GA 55 Editable'!F16)","v":0},{"$f":"IF('GA 55 Editable'!G16=\"\",\"\",'GA 55 Editable'!G16)","v":0},{"$f":"IF('GA 55 Editable'!H16=\"\",\"\",'GA 55 Editable'!H16)","v":0},{"$f":"IF('GA 55 Editable'!I16=\"\",\"\",'GA 55 Editable'!I16)","v":""},{"$f":"IF('GA 55 Editable'!J16=\"\",\"\",'GA 55 Editable'!J16)","v":{"v":75460,"d":"75,460"}},{"$f":"IF('GA 55 Editable'!K16=\"\",\"\",'GA 55 Editable'!K16)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L16=\"\",\"\",'GA 55 Editable'!L16)","v":0},{"$f":"IF('GA 55 Editable'!M16=\"\",\"\",'GA 55 Editable'!M16)","v":{"v":7061,"d":"7,061"}},{"$f":"IF('GA 55 Editable'!N16=\"\",\"\",'GA 55 Editable'!N16)","v":0},{"$f":"IF('GA 55 Editable'!O16=\"\",\"\",'GA 55 Editable'!O16)","v":330},{"$f":"IF('GA 55 Editable'!P16=\"\",\"\",'GA 55 Editable'!P16)","v":""},{"$f":"IF('GA 55 Editable'!Q16=\"\",\"\",'GA 55 Editable'!Q16)","v":0},{"$f":"IF('GA 55 Editable'!R16=\"\",\"\",'GA 55 Editable'!R16)","v":""},{"$f":"IF('GA 55 Editable'!S16=\"\",\"\",'GA 55 Editable'!S16)","v":0},{"$f":"IF('GA 55 Editable'!T16=\"\",\"\",'GA 55 Editable'!T16)","v":""},{"$f":"IF('GA 55 Editable'!U16=\"\",\"\",'GA 55 Editable'!U16)","v":""},{"$f":"IF('GA 55 Editable'!V16=\"\",\"\",'GA 55 Editable'!V16)","v":500},{"$f":"IF('GA 55 Editable'!W16=\"\",\"\",'GA 55 Editable'!W16)","v":""},{"$f":"IF('GA 55 Editable'!X16=\"\",\"\",'GA 55 Editable'!X16)","v":0},{"$f":"IF('GA 55 Editable'!Y16=\"\",\"\",'GA 55 Editable'!Y16)","v":{"v":10891,"d":"10,891"}},{"$f":"IF('GA 55 Editable'!Z16=\"\",\"\",'GA 55 Editable'!Z16)","v":{"v":64569,"d":"64,569"}},{"$f":"IF('GA 55 Editable'!AA16=\"\",\"\",'GA 55 Editable'!AA16)","v":""}]
[1,"2022-01-01",{"$f":"IF('GA 55 Editable'!C17=\"\",\"\",'GA 55 Editable'!C17)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D17=\"\",\"\",'GA 55 Editable'!D17)","v":{"v":16709,"d":"16,709"}},{"$f":"IF('GA 55 Editable'!E17=\"\",\"\",'GA 55 Editable'!E17)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F17=\"\",\"\",'GA 55 Editable'!F17)","v":0},{"$f":"IF('GA 55 Editable'!G17=\"\",\"\",'GA 55 Editable'!G17)","v":0},{"$f":"IF('GA 55 Editable'!H17=\"\",\"\",'GA 55 Editable'!H17)","v":0},{"$f":"IF('GA 55 Editable'!I17=\"\",\"\",'GA 55 Editable'!I17)","v":""},{"$f":"IF('GA 55 Editable'!J17=\"\",\"\",'GA 55 Editable'!J17)","v":{"v":75460,"d":"75,460"}},{"$f":"IF('GA 55 Editable'!K17=\"\",\"\",'GA 55 Editable'!K17)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L17=\"\",\"\",'GA 55 Editable'!L17)","v":0},{"$f":"IF('GA 55 Editable'!M17=\"\",\"\",'GA 55 Editable'!M17)","v":{"v":7061,"d":"7,061"}},{"$f":"IF('GA 55 Editable'!N17=\"\",\"\",'GA 55 Editable'!N17)","v":0},{"$f":"IF('GA 55 Editable'!O17=\"\",\"\",'GA 55 Editable'!O17)","v":330},{"$f":"IF('GA 55 Editable'!P17=\"\",\"\",'GA 55 Editable'!P17)","v":""},{"$f":"IF('GA 55 Editable'!Q17=\"\",\"\",'GA 55 Editable'!Q17)","v":0},{"$f":"IF('GA 55 Editable'!R17=\"\",\"\",'GA 55 Editable'!R17)","v":""},{"$f":"IF('GA 55 Editable'!S17=\"\",\"\",'GA 55 Editable'!S17)","v":0},{"$f":"IF('GA 55 Editable'!T17=\"\",\"\",'GA 55 Editable'!T17)","v":""},{"$f":"IF('GA 55 Editable'!U17=\"\",\"\",'GA 55 Editable'!U17)","v":""},{"$f":"IF('GA 55 Editable'!V17=\"\",\"\",'GA 55 Editable'!V17)","v":""},{"$f":"IF('GA 55 Editable'!W17=\"\",\"\",'GA 55 Editable'!W17)","v":""},{"$f":"IF('GA 55 Editable'!X17=\"\",\"\",'GA 55 Editable'!X17)","v":0},{"$f":"IF('GA 55 Editable'!Y17=\"\",\"\",'GA 55 Editable'!Y17)","v":{"v":10391,"d":"10,391"}},{"$f":"IF('GA 55 Editable'!Z17=\"\",\"\",'GA 55 Editable'!Z17)","v":{"v":65069,"d":"65,069"}},{"$f":"IF('GA 55 Editable'!AA17=\"\",\"\",'GA 55 Editable'!AA17)","v":""}]
[2,"2022-02-01",{"$f":"IF('GA 55 Editable'!C18=\"\",\"\",'GA 55 Editable'!C18)","v":{"v":53900,"d":"53,900"}},{"$f":"IF('GA 55 Editable'!D18=\"\",\"\",'GA 55 Editable'!D18)","v":{"v":16709,"d":"16,709"}},{"$f":"IF('GA 55 Editable'!E18=\"\",\"\",'GA 55 Editable'!E18)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!F18=\"\",\"\",'GA 55 Editable'!F18)","v":0},{"$f":"IF('GA 55 Editable'!G18=\"\",\"\",'GA 55 Editable'!G18)","v":0},{"$f":"IF('GA 55 Editable'!H18=\"\",\"\",'GA 55 Editable'!H18)","v":0},{"$f":"IF('GA 55 Editable'!I18=\"\",\"\",'GA 55 Editable'!I18)","v":""},{"$f":"IF('GA 55 Editable'!J18=\"\",\"\",'GA 55 Editable'!J18)","v":{"v":75460,"d":"75,460"}},{"$f":"IF('GA 55 Editable'!K18=\"\",\"\",'GA 55 Editable'!K18)","v":{"v":3000,"d":"3,000"}},{"$f":"IF('GA 55 Editable'!L18=\"\",\"\",'GA 55 Editable'!L18)","v":0},{"$f":"IF('GA 55 Editable'!M18=\"\",\"\",'GA 55 Editable'!M18)","v":{"v":7061,"d":"7,061"}},{"$f":"IF('GA 55 Editable'!N18=\"\",\"\",'GA 55 Editable'!N18)","v":0},{"$f":"IF('GA 55 Editable'!O18=\"\",\"\",'GA 55 Editable'!O18)","v":330},{"$f":"IF('GA 55 Editable'!P18=\"\",\"\",'GA 55 Editable'!P18)","v":""},{"$f":"IF('GA 55 Editable'!Q18=\"\",\"\",'GA 55 Editable'!Q18)","v":0},{"$f":"IF('GA 55 Editable'!R18=\"\",\"\",'GA 55 Editable'!R18)","v":""},{"$f":"IF('GA 55 Editable'!S18=\"\",\"\",'GA 55 Editable'!S18)","v":0},{"$f":"IF('GA 55 Editable'!T18=\"\",\"\",'GA 55 Editable'!T18)","v":""},{"$f":"IF('GA 55 Editable'!U18=\"\",\"\",'GA 55 Editable'!U18)","v":""},{"$f":"IF('GA 55 Editable'!V18=\"\",\"\",'GA 55 Editable'!V18)","v":""},{"$f":"IF('GA 55 Editable'!W18=\"\",\"\",'GA 55 Editable'!W18)","v":""},{"$f":"IF('GA 55 Editable'!X18=\"\",\"\",'GA 55 Editable'!X18)","v":0},{"$f":"IF('GA 55 Editable'!Y18=\"\",\"\",'GA 55 Editable'!Y18)","v":{"v":10391,"d":"10,391"}},{"$f":"IF('GA 55 Editable'!Z18=\"\",\"\",'GA 55 Editable'!Z18)","v":{"v":65069,"d":"65,069"}},{"$f":"IF('GA 55 Editable'!AA18=\"\",\"\",'GA 55 Editable'!AA18)","v":""}]
[null,"HRA Arrear July 2021",{"$f":"IF('GA 55 Editable'!C19=\"\",\"\",'GA 55 Editable'!C19)","v":""},{"$f":"IF('GA 55 Editable'!D19=\"\",\"\",'GA 55 Editable'!D19)","v":""},{"$f":"IF('GA 55 Editable'!E19=\"\",\"\",'GA 55 Editable'!E19)","v":539},{"$f":"IF('GA 55 Editable'!F19=\"\",\"\",'GA 55 Editable'!F19)","v":""},{"$f":"IF('GA 55 Editable'!G19=\"\",\"\",'GA 55 Editable'!G19)","v":""},{"$f":"IF('GA 55 Editable'!H19=\"\",\"\",'GA 55 Editable'!H19)","v":""},{"$f":"IF('GA 55 Editable'!I19=\"\",\"\",'GA 55 Editable'!I19)","v":""},{"$f":"IF('GA 55 Editable'!J19=\"\",\"\",'GA 55 Editable'!J19)","v":539},{"$f":"IF('GA 55 Editable'!K19=\"\",\"\",'GA 55 Editable'!K19)","v":""},{"$f":"IF('GA 55 Editable'!L19=\"\",\"\",'GA 55 Editable'!L19)","v":0},{"$f":"IF('GA 55 Editable'!M19=\"\",\"\",'GA 55 Editable'!M19)","v":""},{"$f":"IF('GA 55 Editable'!N19=\"\",\"\",'GA 55 Editable'!N19)","v":""},{"$f":"IF('GA 55 Editable'!O19=\"\",\"\",'GA 55 Editable'!O19)","v":""},{"$f":"IF('GA 55 Editable'!P19=\"\",\"\",'GA 55 Editable'!P19)","v":""},{"$f":"IF('GA 55 Editable'!Q19=\"\",\"\",'GA 55 Editable'!Q19)","v":""},{"$f":"IF('GA 55 Editable'!R19=\"\",\"\",'GA 55 Editable'!R19)","v":""},{"$f":"IF('GA 55 Editable'!S19=\"\",\"\",'GA 55 Editable'!S19)","v":""},{"$f":"IF('GA 55 Editable'!T19=\"\",\"\",'GA 55 Editable'!T19)","v":""},{"$f":"IF('GA 55 Editable'!U19=\"\",\"\",'GA 55 Editable'!U19)","v":""},{"$f":"IF('GA 55 Editable'!V19=\"\",\"\",'GA 55 Editable'!V19)","v":""},{"$f":"IF('GA 55 Editable'!W19=\"\",\"\",'GA 55 Editable'!W19)","v":""},{"$f":"IF('GA 55 Editable'!X19=\"\",\"\",'GA 55 Editable'!X19)","v":""},{"$f":"IF('GA 55 Editable'!Y19=\"\",\"\",'GA 55 Editable'!Y19)","v":0},{"$f":"IF('GA 55 Editable'!Z19=\"\",\"\",'GA 55 Editable'!Z19)","v":539},{"$f":"IF('GA 55 Editable'!AA19=\"\",\"\",'GA 55 Editable'!AA19)","v":""}]
[null,"Bonus",{"$f":"IF('GA 55 Editable'!C20=\"\",\"\",'GA 55 Editable'!C20)","v":{"v":6774,"d":"6,774"}},{"$f":"IF('GA 55 Editable'!D20=\"\",\"\",'GA 55 Editable'!D20)","v":""},{"$f":"IF('GA 55 Editable'!E20=\"\",\"\",'GA 55 Editable'!E20)","v":""},{"$f":"IF('GA 55 Editable'!F20=\"\",\"\",'GA 55 Editable'!F20)","v":""},{"$f":"IF('GA 55 Editable'!G20=\"\",\"\",'GA 55 Editable'!G20)","v":""},{"$f":"IF('GA 55 Editable'!H20=\"\",\"\",'GA 55 Editable'!H20)","v":""},{"$f":"IF('GA 55 Editable'!I20=\"\",\"\",'GA 55 Editable'!I20)","v":""},{"$f":"IF('GA 55 Editable'!J20=\"\",\"\",'GA 55 Editable'!J20)","v":{"v":6774,"d":"6,774"}},{"$f":"IF('GA 55 Editable'!K20=\"\",\"\",'GA 55 Editable'!K20)","v":""},{"$f":"IF('GA 55 Editable'!L20=\"\",\"\",'GA 55 Editable'!L20)","v":0},{"$f":"IF('GA 55 Editable'!M20=\"\",\"\",'GA 55 Editable'!M20)","v":""},{"$f":"IF('GA 55 Editable'!N20=\"\",\"\",'GA 55 Editable'!N20)","v":""},{"$f":"IF('GA 55 Editable'!O20=\"\",\"\",'GA 55 Editable'!O20)","v":""},{"$f":"IF('GA 55 Editable'!P20=\"\",\"\",'GA 55 Editable'!P20)","v":""},{"$f":"IF('GA 55 Editable'!Q20=\"\",\"\",'GA 55 Editable'!Q20)","v":""},{"$f":"IF('GA 55 Editable'!R20=\"\",\"\",'GA 55 Editable'!R20)","v":""},{"$f":"IF('GA 55 Editable'!S20=\"\",\"\",'GA 55 Editable'!S20)","v":""},{"$f":"IF('GA 55 Editable'!T20=\"\",\"\",'GA 55 Editable'!T20)","v":""},{"$f":"IF('GA 55 Editable'!U20=\"\",\"\",'GA 55 Editable'!U20)","v":{"v":3387,"d":"3,387"}},{"$f":"IF('GA 55 Editable'!V20=\"\",\"\",'GA 55 Editable'!V20)","v":""},{"$f":"IF('GA 55 Editable'!W20=\"\",\"\",'GA 55 Editable'!W20)","v":""},{"$f":"IF('GA 55 Editable'!X20=\"\",\"\",'GA 55 Editable'!X20)","v":""},{"$f":"IF('GA 55 Editable'!Y20=\"\",\"\",'GA 55 Editable'!Y20)","v":{"v":3387,"d":"3,387"}},{"$f":"IF('GA 55 Editable'!Z20=\"\",\"\",'GA 55 Editable'!Z20)","v":{"v":3387,"d":"3,387"}},{"$f":"IF('GA 55 Editable'!AA20=\"\",\"\",'GA 55 Editable'!AA20)","v":""}]
[null,"Surrender",{"$f":"IF('GA 55 Editable'!C21=\"\",\"\",'GA 55 Editable'!C21)","v":0},{"$f":"IF('GA 55 Editable'!D21=\"\",\"\",'GA 55 Editable'!D21)","v":0},{"$f":"IF('GA 55 Editable'!E21=\"\",\"\",'GA 55 Editable'!E21)","v":""},{"$f":"IF('GA 55 Editable'!F21=\"\",\"\",'GA 55 Editable'!F21)","v":""},{"$f":"IF('GA 55 Editable'!G21=\"\",\"\",'GA 55 Editable'!G21)","v":""},{"$f":"IF('GA 55 Editable'!H21=\"\",\"\",'GA 55 Editable'!H21)","v":""},{"$f":"IF('GA 55 Editable'!I21=\"\",\"\",'GA 55 Editable'!I21)","v":""},{"$f":"IF('GA 55 Editable'!J21=\"\",\"\",'GA 55 Editable'!J21)","v":0},{"$f":"IF('GA 55 Editable'!K21=\"\",\"\",'GA 55 Editable'!K21)","v":""},{"$f":"IF('GA 55 Editable'!L21=\"\",\"\",'GA 55 Editable'!L21)","v":""},{"$f":"IF('GA 55 Editable'!M21=\"\",\"\",'GA 55 Editable'!M21)","v":""},{"$f":"IF('GA 55 Editable'!N21=\"\",\"\",'GA 55 Editable'!N21)","v":""},{"$f":"IF('GA 55 Editable'!O21=\"\",\"\",'GA 55 Editable'!O21)","v":""},{"$f":"IF('GA 55 Editable'!P21=\"\",\"\",'GA 55 Editable'!P21)","v":""},{"$f":"IF('GA 55 Editable'!Q21=\"\",\"\",'GA 55 Editable'!Q21)","v":""},{"$f":"IF('GA 55 Editable'!R21=\"\",\"\",'GA 55 Editable'!R21)","v":""},{"$f":"IF('GA 55 Editable'!S21=\"\",\"\",'GA 55 Editable'!S21)","v":""},{"$f":"IF('GA 55 Editable'!T21=\"\",\"\",'GA 55 Editable'!T21)","v":""},{"$f":"IF('GA 55 Editable'!U21=\"\",\"\",'GA 55 Editable'!U21)","v":""},{"$f":"IF('GA 55 Editable'!V21=\"\",\"\",'GA 55 Editable'!V21)","v":""},{"$f":"IF('GA 55 Editable'!W21=\"\",\"\",'GA 55 Editable'!W21)","v":""},{"$f":"IF('GA 55 Editable'!X21=\"\",\"\",'GA 55 Editable'!X21)","v":""},{"$f":"IF('GA 55 Editable'!Y21=\"\",\"\",'GA 55 Editable'!Y21)","v":0},{"$f":"IF('GA 55 Editable'!Z21=\"\",\"\",'GA 55 Editable'!Z21)","v":0},{"$f":"IF('GA 55 Editable'!AA21=\"\",\"\",'GA 55 Editable'!AA21)","v":""}]
[null,"DA Arrear",{"$f":"IF('GA 55 Editable'!C22=\"\",\"\",'GA 55 Editable'!C22)","v":""},{"$f":"IF('GA 55 Editable'!D22=\"\",\"\",'GA 55 Editable'!D22)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!E22=\"\",\"\",'GA 55 Editable'!E22)","v":""},{"$f":"IF('GA 55 Editable'!F22=\"\",\"\",'GA 55 Editable'!F22)","v":""},{"$f":"IF('GA 55 Editable'!G22=\"\",\"\",'GA 55 Editable'!G22)","v":""},{"$f":"IF('GA 55 Editable'!H22=\"\",\"\",'GA 55 Editable'!H22)","v":""},{"$f":"IF('GA 55 Editable'!I22=\"\",\"\",'GA 55 Editable'!I22)","v":""},{"$f":"IF('GA 55 Editable'!J22=\"\",\"\",'GA 55 Editable'!J22)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!K22=\"\",\"\",'GA 55 Editable'!K22)","v":""},{"$f":"IF('GA 55 Editable'!L22=\"\",\"\",'GA 55 Editable'!L22)","v":0},{"$f":"IF('GA 55 Editable'!M22=\"\",\"\",'GA 55 Editable'!M22)","v":486},{"$f":"IF('GA 55 Editable'!N22=\"\",\"\",'GA 55 Editable'!N22)","v":""},{"$f":"IF('GA 55 Editable'!O22=\"\",\"\",'GA 55 Editable'!O22)","v":""},{"$f":"IF('GA 55 Editable'!P22=\"\",\"\",'GA 55 Editable'!P22)","v":""},{"$f":"IF('GA 55 Editable'!Q22=\"\",\"\",'GA 55 Editable'!Q22)","v":""},{"$f":"IF('GA 55 Editable'!R22=\"\",\"\",'GA 55 Editable'!R22)","v":""},{"$f":"IF('GA 55 Editable'!S22=\"\",\"\",'GA 55 Editable'!S22)","v":""},{"$f":"IF('GA 55 Editable'!T22=\"\",\"\",'GA 55 Editable'!T22)","v":""},{"$f":"IF('GA 55 Editable'!U22=\"\",\"\",'GA 55 Editable'!U22)","v":{"v":4365,"d":"4,365"}},{"$f":"IF('GA 55 Editable'!V22=\"\",\"\",'GA 55 Editable'!V22)","v":""},{"$f":"IF('GA 55 Editable'!W22=\"\",\"\",'GA 55 Editable'!W22)","v":""},{"$f":"IF('GA 55 Editable'!X22=\"\",\"\",'GA 55 Editable'!X22)","v":""},{"$f":"IF('GA 55 Editable'!Y22=\"\",\"\",'GA 55 Editable'!Y22)","v":{"v":4851,"d":"4,851"}},{"$f":"IF('GA 55 Editable'!Z22=\"\",\"\",'GA 55 Editable'!Z22)","v":0},{"$f":"IF('GA 55 Editable'!AA22=\"\",\"\",'GA 55 Editable'!AA22)","v":""}]
[null,"Fixation Arrear",{"$f":"IF('GA 55 Editable'!C23=\"\",\"\",'GA 55 Editable'!C23)","v":""},{"$f":"IF('GA 55 Editable'!D23=\"\",\"\",'GA 55 Editable'!D23)","v":""},{"$f":"IF('GA 55 Editable'!E23=\"\",\"\",'GA 55 Editable'!E23)","v":""},{"$f":"IF('GA 55 Editable'!F23=\"\",\"\",'GA 55 Editable'!F23)","v":""},{"$f":"IF('GA 55 Editable'!G23=\"\",\"\",'GA 55 Editable'!G23)","v":""},{"$f":"IF('GA 55 Editable'!H23=\"\",\"\",'GA 55 Editable'!H23)","v":""},{"$f":"IF('GA 55 Editable'!I23=\"\",\"\",'GA 55 Editable'!I23)","v":""},{"$f":"IF('GA 55 Editable'!J23=\"\",\"\",'GA 55 Editable'!J23)","v":0},{"$f":"IF('GA 55 Editable'!K23=\"\",\"\",'GA 55 Editable'!K23)","v":""},{"$f":"IF('GA 55 Editable'!L23=\"\",\"\",'GA 55 Editable'!L23)","v":""},{"$f":"IF('GA 55 Editable'!M23=\"\",\"\",'GA 55 Editable'!M23)","v":0},{"$f":"IF('GA 55 Editable'!N23=\"\",\"\",'GA 55 Editable'!N23)","v":""},{"$f":"IF('GA 55 Editable'!O23=\"\",\"\",'GA 55 Editable'!O23)","v":""},{"$f":"IF('GA 55 Editable'!P23=\"\",\"\",'GA 55 Editable'!P23)","v":""},{"$f":"IF('GA 55 Editable'!Q23=\"\",\"\",'GA 55 Editable'!Q23)","v":""},{"$f":"IF('GA 55 Editable'!R23=\"\",\"\",'GA 55 Editable'!R23)","v":""},{"$f":"IF('GA 55 Editable'!S23=\"\",\"\",'GA 55 Editable'!S23)","v":""},{"$f":"IF('GA 55 Editable'!T23=\"\",\"\",'GA 55 Editable'!T23)","v":""},{"$f":"IF('GA 55 Editable'!U23=\"\",\"\",'GA 55 Editable'!U23)","v":""},{"$f":"IF('GA 55 Editable'!V23=\"\",\"\",'GA 55 Editable'!V23)","v":""},{"$f":"IF('GA 55 Editable'!W23=\"\",\"\",'GA 55 Editable'!W23)","v":""},{"$f":"IF('GA 55 Editable'!X23=\"\",\"\",'GA 55 Editable'!X23)","v":""},{"$f":"IF('GA 55 Editable'!Y23=\"\",\"\",'GA 55 Editable'!Y23)","v":0},{"$f":"IF('GA 55 Editable'!Z23=\"\",\"\",'GA 55 Editable'!Z23)","v":0},{"$f":"IF('GA 55 Editable'!AA23=\"\",\"\",'GA 55 Editable'!AA23)","v":""}]
[null,"March Due Salary",{"$f":"IF('GA 55 Editable'!C24=\"\",\"\",'GA 55 Editable'!C24)","v":""},{"$f":"IF('GA 55 Editable'!D24=\"\",\"\",'GA 55 Editable'!D24)","v":""},{"$f":"IF('GA 55 Editable'!E24=\"\",\"\",'GA 55 Editable'!E24)","v":""},{"$f":"IF('GA 55 Editable'!F24=\"\",\"\",'GA 55 Editable'!F24)","v":""},{"$f":"IF('GA 55 Editable'!G24=\"\",\"\",'GA 55 Editable'!G24)","v":""},{"$f":"IF('GA 55 Editable'!H24=\"\",\"\",'GA 55 Editable'!H24)","v":""},{"$f":"IF('GA 55 Editable'!I24=\"\",\"\",'GA 55 Editable'!I24)","v":""},{"$f":"IF('GA 55 Editable'!J24=\"\",\"\",'GA 55 Editable'!J24)","v":0},{"$f":"IF('GA 55 Editable'!K24=\"\",\"\",'GA 55 Editable'!K24)","v":""},{"$f":"IF('GA 55 Editable'!L24=\"\",\"\",'GA 55 Editable'!L24)","v":""},{"$f":"IF('GA 55 Editable'!M24=\"\",\"\",'GA 55 Editable'!M24)","v":0},{"$f":"IF('GA 55 Editable'!N24=\"\",\"\",'GA 55 Editable'!N24)","v":""},{"$f":"IF('GA 55 Editable'!O24=\"\",\"\",'GA 55 Editable'!O24)","v":""},{"$f":"IF('GA 55 Editable'!P24=\"\",\"\",'GA 55 Editable'!P24)","v":""},{"$f":"IF('GA 55 Editable'!Q24=\"\",\"\",'GA 55 Editable'!Q24)","v":""},{"$f":"IF('GA 55 Editable'!R24=\"\",\"\",'GA 55 Editable'!R24)","v":""},{"$f":"IF('GA 55 Editable'!S24=\"\",\"\",'GA 55 Editable'!S24)","v":""},{"$f":"IF('GA 55 Editable'!T24=\"\",\"\",'GA 55 Editable'!T24)","v":""},{"$f":"IF('GA 55 Editable'!U24=\"\",\"\",'GA 55 Editable'!U24)","v":""},{"$f":"IF('GA 55 Editable'!V24=\"\",\"\",'GA 55 Editable'!V24)","v":""},{"$f":"IF('GA 55 Editable'!W24=\"\",\"\",'GA 55 Editable'!W24)","v":""},{"$f":"IF('GA 55 Editable'!X24=\"\",\"\",'GA 55 Editable'!X24)","v":""},{"$f":"IF('GA 55 Editable'!Y24=\"\",\"\",'GA 55 Editable'!Y24)","v":0},{"$f":"IF('GA 55 Editable'!Z24=\"\",\"\",'GA 55 Editable'!Z24)","v":0},{"$f":"IF('GA 55 Editable'!AA24=\"\",\"\",'GA 55 Editable'!AA24)","v":""}]
[null,"Salary Arrear1",{"$f":"IF('GA 55 Editable'!C25=\"\",\"\",'GA 55 Editable'!C25)","v":""},{"$f":"IF('GA 55 Editable'!D25=\"\",\"\",'GA 55 Editable'!D25)","v":""},{"$f":"IF('GA 55 Editable'!E25=\"\",\"\",'GA 55 Editable'!E25)","v":""},{"$f":"IF('GA 55 Editable'!F25=\"\",\"\",'GA 55 Editable'!F25)","v":""},{"$f":"IF('GA 55 Editable'!G25=\"\",\"\",'GA 55 Editable'!G25)","v":""},{"$f":"IF('GA 55 Editable'!H25=\"\",\"\",'GA 55 Editable'!H25)","v":""},{"$f":"IF('GA 55 Editable'!I25=\"\",\"\",'GA 55 Editable'!I25)","v":""},{"$f":"IF('GA 55 Editable'!J25=\"\",\"\",'GA 55 Editable'!J25)","v":0},{"$f":"IF('GA 55 Editable'!K25=\"\",\"\",'GA 55 Editable'!K25)","v":""},{"$f":"IF('GA 55 Editable'!L25=\"\",\"\",'GA 55 Editable'!L25)","v":""},{"$f":"IF('GA 55 Editable'!M25=\"\",\"\",'GA 55 Editable'!M25)","v":0},{"$f":"IF('GA 55 Editable'!N25=\"\",\"\",'GA 55 Editable'!N25)","v":""},{"$f":"IF('GA 55 Editable'!O25=\"\",\"\",'GA 55 Editable'!O25)","v":""},{"$f":"IF('GA 55 Editable'!P25=\"\",\"\",'GA 55 Editable'!P25)","v":""},{"$f":"IF('GA 55 Editable'!Q25=\"\",\"\",'GA 55 Editable'!Q25)","v":""},{"$f":"IF('GA 55 Editable'!R25=\"\",\"\",'GA 55 Editable'!R25)","v":""},{"$f":"IF('GA 55 Editable'!S25=\"\",\"\",'GA 55 Editable'!S25)","v":""},{"$f":"IF('GA 55 Editable'!T25=\"\",\"\",'GA 55 Editable'!T25)","v":""},{"$f":"IF('GA 55 Editable'!U25=\"\",\"\",'GA 55 Editable'!U25)","v":""},{"$f":"IF('GA 55 Editable'!V25=\"\",\"\",'GA 55 Editable'!V25)","v":""},{"$f":"IF('GA 55 Editable'!W25=\"\",\"\",'GA 55 Editable'!W25)","v":""},{"$f":"IF('GA 55 Editable'!X25=\"\",\"\",'GA 55 Editable'!X25)","v":""},{"$f":"IF('GA 55 Editable'!Y25=\"\",\"\",'GA 55 Editable'!Y25)","v":0},{"$f":"IF('GA 55 Editable'!Z25=\"\",\"\",'GA 55 Editable'!Z25)","v":0},{"$f":"IF('GA 55 Editable'!AA25=\"\",\"\",'GA 55 Editable'!AA25)","v":""}]
[null,"Salary Arrear2",{"$f":"IF('GA 55 Editable'!C26=\"\",\"\",'GA 55 Editable'!C26)","v":""},{"$f":"IF('GA 55 Editable'!D26=\"\",\"\",'GA 55 Editable'!D26)","v":""},{"$f":"IF('GA 55 Editable'!E26=\"\",\"\",'GA 55 Editable'!E26)","v":""},{"$f":"IF('GA 55 Editable'!F26=\"\",\"\",'GA 55 Editable'!F26)","v":""},{"$f":"IF('GA 55 Editable'!G26=\"\",\"\",'GA 55 Editable'!G26)","v":""},{"$f":"IF('GA 55 Editable'!H26=\"\",\"\",'GA 55 Editable'!H26)","v":""},{"$f":"IF('GA 55 Editable'!I26=\"\",\"\",'GA 55 Editable'!I26)","v":""},{"$f":"IF('GA 55 Editable'!J26=\"\",\"\",'GA 55 Editable'!J26)","v":0},{"$f":"IF('GA 55 Editable'!K26=\"\",\"\",'GA 55 Editable'!K26)","v":""},{"$f":"IF('GA 55 Editable'!L26=\"\",\"\",'GA 55 Editable'!L26)","v":""},{"$f":"IF('GA 55 Editable'!M26=\"\",\"\",'GA 55 Editable'!M26)","v":0},{"$f":"IF('GA 55 Editable'!N26=\"\",\"\",'GA 55 Editable'!N26)","v":""},{"$f":"IF('GA 55 Editable'!O26=\"\",\"\",'GA 55 Editable'!O26)","v":""},{"$f":"IF('GA 55 Editable'!P26=\"\",\"\",'GA 55 Editable'!P26)","v":""},{"$f":"IF('GA 55 Editable'!Q26=\"\",\"\",'GA 55 Editable'!Q26)","v":""},{"$f":"IF('GA 55 Editable'!R26=\"\",\"\",'GA 55 Editable'!R26)","v":""},{"$f":"IF('GA 55 Editable'!S26=\"\",\"\",'GA 55 Editable'!S26)","v":""},{"$f":"IF('GA 55 Editable'!T26=\"\",\"\",'GA 55 Editable'!T26)","v":""},{"$f":"IF('GA 55 Editable'!U26=\"\",\"\",'GA 55 Editable'!U26)","v":""},{"$f":"IF('GA 55 Editable'!V26=\"\",\"\",'GA 55 Editable'!V26)","v":""},{"$f":"IF('GA 55 Editable'!W26=\"\",\"\",'GA 55 Editable'!W26)","v":""},{"$f":"IF('GA 55 Editable'!X26=\"\",\"\",'GA 55 Editable'!X26)","v":""},{"$f":"IF('GA 55 Editable'!Y26=\"\",\"\",'GA 55 Editable'!Y26)","v":0},{"$f":"IF('GA 55 Editable'!Z26=\"\",\"\",'GA 55 Editable'!Z26)","v":0},{"$f":"IF('GA 55 Editable'!AA26=\"\",\"\",'GA 55 Editable'!AA26)","v":""}]
[null,"Other",{"$f":"IF('GA 55 Editable'!C27=\"\",\"\",'GA 55 Editable'!C27)","v":""},{"$f":"IF('GA 55 Editable'!D27=\"\",\"\",'GA 55 Editable'!D27)","v":""},{"$f":"IF('GA 55 Editable'!E27=\"\",\"\",'GA 55 Editable'!E27)","v":""},{"$f":"IF('GA 55 Editable'!F27=\"\",\"\",'GA 55 Editable'!F27)","v":""},{"$f":"IF('GA 55 Editable'!G27=\"\",\"\",'GA 55 Editable'!G27)","v":""},{"$f":"IF('GA 55 Editable'!H27=\"\",\"\",'GA 55 Editable'!H27)","v":""},{"$f":"IF('GA 55 Editable'!I27=\"\",\"\",'GA 55 Editable'!I27)","v":""},{"$f":"IF('GA 55 Editable'!J27=\"\",\"\",'GA 55 Editable'!J27)","v":0},{"$f":"IF('GA 55 Editable'!K27=\"\",\"\",'GA 55 Editable'!K27)","v":""},{"$f":"IF('GA 55 Editable'!L27=\"\",\"\",'GA 55 Editable'!L27)","v":""},{"$f":"IF('GA 55 Editable'!M27=\"\",\"\",'GA 55 Editable'!M27)","v":0},{"$f":"IF('GA 55 Editable'!N27=\"\",\"\",'GA 55 Editable'!N27)","v":""},{"$f":"IF('GA 55 Editable'!O27=\"\",\"\",'GA 55 Editable'!O27)","v":""},{"$f":"IF('GA 55 Editable'!P27=\"\",\"\",'GA 55 Editable'!P27)","v":""},{"$f":"IF('GA 55 Editable'!Q27=\"\",\"\",'GA 55 Editable'!Q27)","v":""},{"$f":"IF('GA 55 Editable'!R27=\"\",\"\",'GA 55 Editable'!R27)","v":""},{"$f":"IF('GA 55 Editable'!S27=\"\",\"\",'GA 55 Editable'!S27)","v":""},{"$f":"IF('GA 55 Editable'!T27=\"\",\"\",'GA 55 Editable'!T27)","v":""},{"$f":"IF('GA 55 Editable'!U27=\"\",\"\",'GA 55 Editable'!U27)","v":""},{"$f":"IF('GA 55 Editable'!V27=\"\",\"\",'GA 55 Editable'!V27)","v":""},{"$f":"IF('GA 55 Editable'!W27=\"\",\"\",'GA 55 Editable'!W27)","v":""},{"$f":"IF('GA 55 Editable'!X27=\"\",\"\",'GA 55 Editable'!X27)","v":""},{"$f":"IF('GA 55 Editable'!Y27=\"\",\"\",'GA 55 Editable'!Y27)","v":0},{"$f":"IF('GA 55 Editable'!Z27=\"\",\"\",'GA 55 Editable'!Z27)","v":0},{"$f":"IF('GA 55 Editable'!AA27=\"\",\"\",'GA 55 Editable'!AA27)","v":""}]
[null,"Total",{"$f":"IF('GA 55 Editable'!C28=\"\",\"\",'GA 55 Editable'!C28)","v":{"v":647174,"d":"647,174"}},{"$f":"IF('GA 55 Editable'!D28=\"\",\"\",'GA 55 Editable'!D28)","v":{"v":169236,"d":"169,236"}},{"$f":"IF('GA 55 Editable'!E28=\"\",\"\",'GA 55 Editable'!E28)","v":{"v":55544,"d":"55,544"}},{"$f":"IF('GA 55 Editable'!F28=\"\",\"\",'GA 55 Editable'!F28)","v":0},{"$f":"IF('GA 55 Editable'!G28=\"\",\"\",'GA 55 Editable'!G28)","v":0},{"$f":"IF('GA 55 Editable'!H28=\"\",\"\",'GA 55 Editable'!H28)","v":0},{"$f":"IF('GA 55 Editable'!I28=\"\",\"\",'GA 55 Editable'!I28)","v":0},{"$f":"IF('GA 55 Editable'!J28=\"\",\"\",'GA 55 Editable'!J28)","v":{"v":871954,"d":"871,954"}},{"$f":"IF('GA 55 Editable'!K28=\"\",\"\",'GA 55 Editable'!K28)","v":{"v":36000,"d":"36,000"}},{"$f":"IF('GA 55 Editable'!L28=\"\",\"\",'GA 55 Editable'!L28)","v":0},{"$f":"IF('GA 55 Editable'!M28=\"\",\"\",'GA 55 Editable'!M28)","v":{"v":80964,"d":"80,964"}},{"$f":"IF('GA 55 Editable'!N28=\"\",\"\",'GA 55 Editable'!N28)","v":0},{"$f":"IF('GA 55 Editable'!O28=\"\",\"\",'GA 55 Editable'!O28)","v":{"v":2640,"d":"2,640"}},{"$f":"IF('GA 55 Editable'!P28=\"\",\"\",'GA 55 Editable'!P28)","v":0},{"$f":"IF('GA 55 Editable'!Q28=\"\",\"\",'GA 55 Editable'!Q28)","v":0},{"$f":"IF('GA 55 Editable'!R28=\"\",\"\",'GA 55 Editable'!R28)","v":220},{"$f":"IF('GA 55 Editable'!S28=\"\",\"\",'GA 55 Editable'!S28)","v":0},{"$f":"IF('GA 55 Editable'!T28=\"\",\"\",'GA 55 Editable'!T28)","v":0},{"$f":"IF('GA 55 Editable'!U28=\"\",\"\",'GA 55 Editable'!U28)","v":{"v":7752,"d":"7,752"}},{"$f":"IF('GA 55 Editable'!V28=\"\",\"\",'GA 55 Editable'!V28)","v":500},{"$f":"IF('GA 55 Editable'!W28=\"\",\"\",'GA 55 Editable'!W28)","v":0},{"$f":"IF('GA 55 Editable'!X28=\"\",\"\",'GA 55 Editable'!X28)","v":0},{"$f":"IF('GA 55 Editable'!Y28=\"\",\"\",'GA 55 Editable'!Y28)","v":{"v":128076,"d":"128,076"}},{"$f":"IF('GA 55 Editable'!Z28=\"\",\"\",'GA 55 Editable'!Z28)","v":{"v":743878,"d":"743,878"}},{"$f":"IF('GA 55 Editable'!AA28=\"\",\"\",'GA 55 Editable'!AA28)","v":0}]
[]
[]
[null,"Signature Of Employee",{"$nulls":22},"Signature Of DDO"]

{"sheet":"Tax Calculaton Old","index":6,"n_rows":66,"n_cols":13,"rows_kept":66,"merged":[[0,0,0,12],[1,0,1,12],[2,1,2,2],[2,3,2,7],[2,9,2,10],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,0,9,0],[6,1,6,10],[6,12,8,12],[7,1,7,10],[8,1,8,10],[9,1,9,11],[10,1,10,11],[11,0,14,0],[11,1,11,6],[11,7,11,9],[11,10,11,11],[11,12,13,12],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,11],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,11],[14,1,14,11],[15,1,15,11],[16,1,16,11],[17,1,17,11],[18,1,18,12],[19,1,19,12],[20,2,20,4],[20,5,20,6],[20,8,20,10],[20,12,29,12],[21,2,21,4],[21,5,21,6],[21,8,21,10],[22,2,22,4],[22,5,22,6],[22,8,22,10],[23,2,23,4],[23,5,23,6],[23,8,23,10],[24,2,24,4],[24,5,24,6],[24,8,24,10],[25,2,25,4],[25,5,25,6],[25,8,25,10],[26,2,26,4],[26,5,26,6],[26,8,26,10],[27,2,27,4],[27,5,27,6],[27,8,27,10],[28,2,28,4],[28,5,28,6],[28,7,29,7],[28,8,29,10],[28,11,29,11],[29,2,29,4],[29,5,29,6],[30,1,30,11],[31,2,31,11],[32,2,32,11],[33,1,33,11],[34,1,34,11],[35,2,35,11],[36,2,36,11],[37,2,37,11],[38,2,38,11],[39,2,39,11],[40,2,40,11],[41,2,41,11],[42,2,42,11],[43,2,43,11],[44,1,44,11],[45,1,45,11],[46,1,46,11],[47,1,47,11],[48,1,48,11],[49,1,49,4],[49,5,49,8],[49,9,49,11],[50,1,50,3],[50,5,50,7],[50,9,50,10],[51,1,51,3],[51,5,51,7],[51,9,51,10],[52,1,52,3],[52,5,52,7],[52,9,52,10],[53,1,53,3],[53,5,53,7],[53,9,53,10],[54,2,54,11],[55,2,55,11],[56,2,56,11],[57,2,57,11],[58,1,58,11],[59,1,59,11],[60,1,60,11],[61,0,62,0],[61,1,62,2],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[63,0,63,11],[65,0,65,3],[65,11,65,12]]}
[{"$f":"Master!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
["आयकर गणना प्रपत्र वर्ष 2021-22"]
[1,"नाम कर्मचारी",null,{"$f":"IF(Master!B4=\"\",\"\",Master!B4)","v":"Ashwini Kumar Sharma"},{"$nulls":4},"पद",{"$f":"IF(Master!D4=\"\",\"\",Master!D4)","v":"Lecturer"},null,"पैन नं.",{"$f":"IF(Master!B6=\"\",\"\",Master!B6)","v":"AAAA9456A"}]
[2,"आय वर्ष 2020-21 में प्राप्त कुल वेतन -",{"$nulls":10},{"$f":"IF(Master!F9=\"NO\",'GA 55 For Print'!J28,SUM('GA 55 For Print'!J28+'GA 55 For Print'!M28))","v":{"v":952918,"d":"952918.00"}}]
[3,"गृह किराया, धारा 10 (13-A) के अंतर्गत एवं धारा 10 (14) के अंतर्गत अन्य भत्ते जो कर मुक्त है -",{"$nulls":10},{"$f":"SUM('Other Ded.'!D3,'Other Ded.'!G19)","v":{"v":0,"d":"0.00"}}]
[4,"शेष (2-3)",{"$nulls":10},{"$f":"M4-M5","v":{"v":952918,"d":"952918.00"}}]
[5,"(I)Standard Deduction Maxium 50000 धारा 16 (i a)",{"$nulls":9},{"$f":"IF($M$6>50000,50000,$M$6)","v":{"v":50000,"d":"50000.00"}}]
[null,"(II)मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत Maxium 5000",{"$nulls":9},{"$f":"'Other Ded.'!G4","v":{"v":0,"d":"0.00"}}]
[null,"(III)वयवसाय कर धारा 16 (iii) के अंतर्गत",{"$nulls":9},{"$f":"'Other Ded.'!G5","v":{"v":0,"d":"0.00"}}]
[null,"योग 5",{"$nulls":10},{"$f":"SUM(L7:L9)","v":{"v":50000,"d":"50000.00"}}]
[6,"शेष (4-5)",{"$nulls":10},{"$f":"M6-M10","v":{"v":902918,"d":"902918.00"}}]
[7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य",{"$nulls":5},"(2) प्राप्त किराया रूपये",null,null,{"$f":"'Other Ded.'!D4","v":{"v":0,"d":"0.00"}}]
[null,"(ब) घटाइए",null,"किराये का 30%",null,"गृह ऋण पर ब्याज",null,"गृह कर",null,"योग 7 (ब)"]
[{"$nulls":3},{"$f":"ROUND($K$12*0.3,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF('Other Ded.'!D9>200000,200000,'Other Ded.'!D9)","v":{"v":0,"d":"0.00"}},null,{"$f":"'Other Ded.'!D5","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(D14:I14)","v":{"v":0,"d":"0.00"}}]
[null,"शेष - / + (7(अ) एवं 7 (ब) का)",{"$nulls":10},{"$f":"$K$12-$J$14","v":{"v":0,"d":"0.00"}}]
[8,"कुल शेष - / + (6 एवं 7)",{"$nulls":10},{"$f":"$M$11+$M$15","v":{"v":902918,"d":"902918.00"}}]
[9,"अन्य आय",{"$nulls":10},{"$f":"'Other Ded.'!K5","v":{"v":0,"d":"0.00"}}]
[10,"सकल आय (योग 8+9)",{"$nulls":10},{"$f":"SUM(M16:M17)","v":{"v":902918,"d":"902918.00"}}]
[11,"कटौतिया घटाइए - धारा US 80C, 80CCC, 80CCD(1)"]
[null,"(A) अधिकतम सीमा 150000 (धारा 80CCE), धारा 80CCD(2) के अलावा"]
[null,1,"राज्य बीमा (SI)",null,null,{"$f":"SUM('GA 55 For Print'!K28+'GA 55 For Print'!P28)","v":{"v":36000,"d":"36000.00"}},null,11,"EPEF (80CCD1)",null,null,{"$f":"IF(Master!F9=\"Yes\",'Other Ded.'!D6-M33,0)","v":{"v":80964,"d":"80964.00"}}]
[null,2,"LIC",null,null,{"$f":"SUM('GA 55 For Print'!S28,'Other Ded.'!D10)","v":{"v":0,"d":"0.00"}},null,12,"पेंशन प्लान हेतु अंशदान धारा (80CCC)",null,null,{"$f":"'Other Ded.'!G9","v":{"v":0,"d":"0.00"}}]
[null,3,"GPF/GPF2004",null,null,{"$f":"IF(Master!F9=\"Yes\",'GA 55 For Print'!U28,'GA 55 For Print'!L28)","v":{"v":7752,"d":"7752.00"}},null,13,"राष्ट्रीय बचत पत्र पर ब्याज",null,null,{"$f":"'Other Ded.'!D18","v":{"v":0,"d":"0.00"}}]
[null,4,"राष्ट्रीय बचत पत्र (NSC)",null,null,{"$f":"'Other Ded.'!D17","v":{"v":0,"d":"0.00"}},null,14,"ट्यूशन फीस",null,null,{"$f":"'Other Ded.'!D12","v":{"v":0,"d":"0.00"}}]
[null,5,"लोक भविष्य निधि (PPF)",null,null,{"$f":"'Other Ded.'!D13","v":{"v":0,"d":"0.00"}},null,15,"इक्विटी लिंक सेविंग स्कीम",null,null,{"$f":"'Other Ded.'!D20","v":{"v":0,"d":"0.00"}}]
[null,6,"राष्ट्रीय बचत स्कीम (NSS)",null,null,{"$f":"'Other Ded.'!D16","v":{"v":0,"d":"0.00"}},null,16,"Defferred Annuty",null,null,{"$f":"'Other Ded.'!G3","v":{"v":0,"d":"0.00"}}]
[null,7,"GIS",null,null,{"$f":"'GA 55 For Print'!R28","v":{"v":220,"d":"220.00"}},null,17,"PLI",null,null,{"$f":"'Other Ded.'!D11","v":{"v":0,"d":"0.00"}}]
[null,8,"ULIP / वार्षिक प्लान",null,null,{"$f":"'Other Ded.'!D15","v":{"v":0,"d":"0.00"}},null,18,"धारा 80C के अंतर्गत अन्य जमा राशि",null,null,{"$f":"'Other Ded.'!G8","v":{"v":0,"d":"0.00"}}]
[null,9,"Home Loan Premium",null,null,{"$f":"'Other Ded.'!D8","v":{"v":0,"d":"0.00"}},null,19,"योग 1 से 18 तक",null,null,{"$f":"SUM(F21:G30,L21:L28)","v":{"v":124936,"d":"124936.00"}}]
[null,10,"सुकन्या योजना में जमा",null,null,{"$f":"'Other Ded.'!D14","v":{"v":0,"d":"0.00"}}]
[null,"अधिकतम कटौती राशि रूपए 150000 तक ",{"$nulls":10},{"$f":"IF($L$29<150001,ROUND($L$29,0),150000)","v":{"v":124936,"d":"124936.00"}}]
[null,"(B)","घटाइए धारा 80CCD (2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10%)",{"$nulls":9},{"$f":"'Other Ded.'!J6","v":{"v":80964,"d":"80964.00"}}]
[null,"(C)","घटाइए धारा 80CCD (1B)नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रूपए 50000)",{"$nulls":9},{"$f":"IF('Other Ded.'!G10<50000,'Other Ded.'!G10,50000)","v":{"v":0,"d":"0.00"}}]
[null,"योग 11 (A+B+C)",{"$nulls":10},{"$f":"SUM(M31:M33)","v":{"v":205900,"d":"205900.00"}}]
[12,"अन्य कटौतिया"]
[null,1,"धारा 80 D, चिकित्सा बीमा प्रीमियम (स्वयं,पति/पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000,सीनियर सिटीजन रू 50000)",{"$nulls":9},{"$f":"'Other Ded.'!G11","v":{"v":2640,"d":"2640.00"}}]
[null,2,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता 125,000)",{"$nulls":9},{"$f":"'Other Ded.'!G12","v":{"v":0,"d":"0.00"}}]
[null,3,"धारा 80 DB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40,000, सीनियर सिटीजन हेतु रू 100,000)",{"$nulls":9},{"$f":"'Other Ded.'!G13","v":{"v":0,"d":"0.00"}}]
[null,4,"धारा 80 E उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":9},{"$f":"'Other Ded.'!G14","v":{"v":0,"d":"0.00"}}]
[null,5,"धारा 80 G धर्मार्थ संस्थाओं आदि को दिये दान ( क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":9},{"$f":"SUM('Other Ded.'!D7,'Other Ded.'!G20)","v":{"v":0,"d":"0.00"}}]
[null,6,"धारा 80 U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा  अधिनियम 1995के अनुसार 125,000)",{"$nulls":9},{"$f":"'Other Ded.'!G15","v":{"v":0,"d":"0.00"}}]
[null,7,"धारा 80 TTA बचत खाते पर ब्याज की अधिकतम छूट रू. 10,000  U/S 194(IA)",{"$nulls":9},{"$f":"IF(Master!$F$11=\"Yes\",0,IF('Other Ded.'!D19>10000,10000,'Other Ded.'!D19))","v":{"v":0,"d":"0.00"}}]
[null,8,"धारा 80 TTB वरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर अधिकतम छूट-  50000 रू.  U/S 194(A)",{"$nulls":9},{"$f":"IF(Master!$F$11=\"No\",0,IF('Other Ded.'!K4<50001,'Other Ded.'!K4,50000))","v":{"v":0,"d":"0.00"}}]
[null,9,"धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":9},{"$f":"'Other Ded.'!G16","v":{"v":0,"d":"0.00"}}]
[null,"योग 12 (1 to 9)",{"$nulls":10},{"$f":"SUM(M36:M44)","v":{"v":2640,"d":"2640.00"}}]
[13,"कुल कटौती (11+12)",{"$nulls":10},{"$f":"SUM(M34,M45)","v":{"v":208540,"d":"208540.00"}}]
[14,"कर योग्य आय (10-13)",{"$nulls":10},{"$f":"$M$18-$M$46","v":{"v":694378,"d":"694378.00"}}]
[15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288 A ",{"$nulls":10},{"$f":"ROUND($M$47,-1)","v":{"v":694380,"d":"694380.00"}}]
[16,"आयकर की गणना"]
[null,"एक व्यक्ति कर दाता ",{"$nulls":3},"वरिष्ठ नागरिक (60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,"250000 तक",null,null,"NIL","300000 तक",null,null,"NIL",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"250001 से 50000 तक",null,null,{"v":0.05,"d":"5%"},"300001 से 50000 तक",null,null,{"v":0.05,"d":"5%"},"50000 तक",null,"NIL",{"$f":"ROUND(IF(Master!F11=\"NO\",IF(M48<250001,0,IF(M48>500000,12500,((M48-250000)*0.05))),IF(M48<300001,0,IF(M48>500000,10000,((M48-300000)*0.05)))),0)","v":{"v":12500,"d":"12500.00"}}]
[null,"500001 से 1000000 तक",null,null,{"v":0.2,"d":"20%"},"500001 से 1000000 तक",null,null,{"v":0.2,"d":"20%"},"500001 से 1000000 तक",null,{"v":0.2,"d":"20%"},{"$f":"ROUND(IF(M48<500001,0,IF(M48>1000000,100000,((M48-500000)*0.2))),0)","v":{"v":38876,"d":"38876.00"}}]
[null,"1000001 से अधिक",null,null,{"v":0.3,"d":"30%"},"1000001 से अधिक",null,null,{"v":0.3,"d":"30%"},"1000001 से अधिक",null,{"v":0.3,"d":"30%"},{"$f":"ROUND(IF(M48<1000001,0,((M48-1000000)*0.3)),0)","v":{"v":0,"d":"0.00"}}]
[null,1,"योग आयकर",{"$nulls":9},{"$f":"SUM(M51:M54)","v":{"v":51376,"d":"51376.00"}}]
[null,2,"छूट घारा 87(A) (2.50 लाख से 5 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12500 तक)",{"$nulls":9},{"$f":"IF(M48>500000,0,IF(M55<12501,M55,12500))","v":{"v":0,"d":"0.00"}}]
[null,3,"शेष आयकर (1-2)",{"$nulls":9},{"$f":"M55-M56","v":{"v":51376,"d":"51376.00"}}]
[null,4,"शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%  (योग 4%)",{"$nulls":9},{"$f":"ROUND(M57*0.04,0)","v":{"v":2055,"d":"2055.00"}}]
[null,"कुल आयकर (3+4)",{"$nulls":10},{"$f":"SUM(M57:M58)","v":{"v":53431,"d":"53431.00"}}]
[17,"घटाइये :- राहत धारा 89 के तहत",{"$nulls":10},{"$f":"'Other Ded.'!G17","v":{"v":0,"d":"0.00"}}]
[18,"कुल शेष आयकर",{"$nulls":10},{"$f":"M59-M60","v":{"v":53431,"d":"53431.00"}}]
[19,"आयकर कटौती का विवरण",null,"सितम्बर   2021 तक",null,"अक्टूबर से दिसम्बर 2021 तक",null,"जनवरी 2022",null,"फ़रवरी 2022",null,"टी.डी.एस.","कुल टैक्स कटौती (योग कॉलम 19)"]
[{"$nulls":3},{"$f":"SUM('GA 55 For Print'!$X$7:$X$13)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55 For Print'!$X$14:$X$16)","v":{"v":0,"d":"0.00"}},null,{"$f":"'GA 55 For Print'!$X$17","v":{"v":0,"d":"0.00"}},null,{"$f":"'GA 55 For Print'!$X$18","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55 Editable'!$X$19:$X$26)+'Other Ded.'!$G$18","v":{"v":0,"d":"0.00"}},{"$f":"SUM($D$63:$L$63)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(M61>M63,\"Income Tax Payable\",IF(M61<M63,\"Income Tax Refundable\",\"Income Tax No Need\"))","v":"Income Tax Payable"},{"$nulls":11},{"$f":"M61-M63","v":{"v":53431,"d":"53431.00"}}]
[]
["Signature Of Employee",{"$nulls":10},"Signature Of DDO"]

{"sheet":"Tax Calculaton New","index":7,"n_rows":58,"n_cols":13,"rows_kept":58,"merged":[[0,0,0,12],[1,0,1,12],[2,1,2,2],[2,3,2,7],[2,9,2,10],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,0,9,0],[6,1,6,10],[6,12,8,12],[7,1,7,10],[8,1,8,10],[9,1,9,11],[10,1,10,11],[11,0,14,0],[11,1,11,6],[11,7,11,9],[11,10,11,11],[11,12,13,12],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,11],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,11],[14,1,14,11],[15,1,15,11],[16,1,16,11],[17,1,17,11],[18,1,18,12],[19,1,19,11],[20,1,20,11],[21,1,21,11],[22,1,22,11],[23,1,23,11],[24,2,24,11],[25,2,25,11],[26,2,26,11],[27,2,27,11],[28,2,28,11],[29,2,29,11],[30,2,30,11],[31,2,31,11],[32,2,32,11],[33,1,33,11],[34,1,34,11],[35,1,35,11],[36,1,36,11],[37,1,37,11],[38,1,38,4],[38,5,38,8],[38,9,38,11],[39,1,39,3],[39,5,39,7],[39,9,39,10],[40,1,40,3],[40,5,40,7],[40,9,40,10],[41,1,41,3],[41,5,41,7],[41,9,41,10],[42,1,42,3],[42,5,42,7],[42,9,42,10],[43,1,43,3],[43,5,43,7],[43,9,43,10],[44,1,44,3],[44,5,44,7],[44,9,44,10],[45,1,45,3],[45,5,45,7],[45,9,45,10],[46,2,46,11],[47,2,47,11],[48,2,48,11],[49,2,49,11],[50,1,50,11],[51,1,51,11],[52,1,52,11],[53,0,54,0],[53,1,54,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[55,0,55,11],[57,0,57,3],[57,11,57,12]]}
[{"$f":"Master!A1","v":"Office of the Principal DIET Kuchaman City (Nagaur)"}]
["आयकर गणना प्रपत्र वर्ष 2021-22"]
[1,"नाम कर्मचारी",null,{"$f":"Master!B4","v":"Ashwini Kumar Sharma"},{"$nulls":4},"पद",{"$f":"Master!D4","v":"Lecturer"},null,"पैन नं.",{"$f":"Master!B6","v":"AAAA9456A"}]
[2,"आय वर्ष 2020-21 में प्राप्त कुल वेतन -",{"$nulls":10},{"$f":"'Tax Calculaton Old'!M4","v":{"v":952918,"d":"952918.00"}}]
[3,"गृह किराया, धारा 10 (13-A) के अंतर्गत एवं धारा 10 (14) के अंतर्गत अन्य भत्ते जो कर मुक्त है -",{"$nulls":10},{"$f":"SUM('Other Ded.'!D3,'Other Ded.'!G19)","v":{"v":0,"d":"0.00"}}]
[4,"शेष (2-3)",{"$nulls":10},{"$f":"M4-M5","v":{"v":952918,"d":"952918.00"}}]
[5,"(I)Standard Deduction Maxium 50000 धारा 16 (i a)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"(II)मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत Maxium 5000",{"$nulls":9},{"$f":"'Other Ded.'!G4","v":{"v":0,"d":"0.00"}}]
[null,"(III)वयवसाय कर धारा 16 (iii) के अंतर्गत",{"$nulls":9},{"$f":"'Other Ded.'!G5","v":{"v":0,"d":"0.00"}}]
[null,"योग 5",{"$nulls":10},{"$f":"SUM(L7:L9)","v":{"v":0,"d":"0.00"}}]
[6,"शेष (4-5)",{"$nulls":10},{"$f":"M6-M10","v":{"v":952918,"d":"952918.00"}}]
[7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य",{"$nulls":5},"(2) प्राप्त किराया रूपये",null,null,{"v":0,"d":"0.00"}]
[null,"(ब) घटाइए",null,"किराये का 30%",null,"गृह ऋण पर ब्याज",null,"गृह कर",null,"योग 7 (ब)"]
[{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"$f":"SUM(D14:I14)","v":{"v":0,"d":"0.00"}}]
[null,"शेष - / + (7(अ) एवं 7 (ब) का)",{"$nulls":10},{"$f":"$K$12+$J$14","v":{"v":0,"d":"0.00"}}]
[8,"कुल शेष - / + (6 एवं 7)",{"$nulls":10},{"$f":"$M$11-$M$15","v":{"v":952918,"d":"952918.00"}}]
[9,"अन्य आय",{"$nulls":10},{"$f":"'Other Ded.'!K5","v":{"v":0,"d":"0.00"}}]
[10,"सकल आय (योग 8+9)",{"$nulls":10},{"$f":"SUM(M16:M17)","v":{"v":952918,"d":"952918.00"}}]
[11,"कटौतिया घटाइए - धारा US 80C, 80CCC, 80CCD(1)"]
[null,"(A) धारा  US 80C, 80CCC, 80CCD(1) अधिकतम कटौती की राशि",{"$nulls":10},{"v":0,"d":"0.00"}]
[null,"(B) धारा 80CCD(2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10% पृथक से छूट)",{"$nulls":10},{"$f":"'Other Ded.'!J6","v":{"v":80964,"d":"80964.00"}}]
[null,"(C) धारा 80CCD(1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)",{"$nulls":10},{"v":0,"d":"0.00"}]
[null,"योग 11 (A+B+C)",{"$nulls":10},{"$f":"SUM(M20:M22)","v":{"v":80964,"d":"80964.00"}}]
[12,"अन्य कटौतिया"]
[null,1,"धारा 80 D, चिकित्सा बीमा प्रीमियम (स्वयं,पति/पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000,सीनियर सिटीजन रू 50000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,2,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80ः या अधिक विकलांगता 125,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,3,"धारा 80 DB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40,000, सीनियर सिटीजन हेतु रू 100,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,4,"धारा 80 E उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,5,"धारा 80 G धर्मार्थ संस्थाओं आदि को दिये दान ( क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,6,"धारा 80 U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा  अधिनियम 1995के अनुसार 125,000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,7,"धारा 80 TTA बचत खाते पर ब्याज की अधिकतम छूट रू. 10,000  U/S 194(IA)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,8,"धारा 80 TTB वरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर अधिकतम छूट-  50000 रू.  U/S 194(A)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,9,"धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,"योग 12 (1 to 9)",{"$nulls":10},{"$f":"SUM(M25:M33)","v":{"v":0,"d":"0.00"}}]
[13,"कुल कटौती (11+12)",{"$nulls":10},{"$f":"SUM($M$23+$M$34)","v":{"v":80964,"d":"80964.00"}}]
[14,"कर योग्य आय (10-13)",{"$nulls":10},{"$f":"$M$18-$M$35","v":{"v":871954,"d":"871954.00"}}]
[15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288 A ",{"$nulls":10},{"$f":"ROUND($M$36,-1)","v":{"v":871950,"d":"871950.00"}}]
[16,"आयकर की गणना"]
[null,"एक व्यक्ति कर दाता ",{"$nulls":3},"वरिष्ठ नागरिक (60 से 80 वर्ष)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,"250000 तक",null,null,"NIL","300000 तक",null,null,"NIL",null,null,"NIL",{"v":0,"d":"0.00"}]
[null,"250001 से 500000 तक",null,null,{"v":0.05,"d":"5%"},"300001 से 500000 तक",null,null,{"v":0.05,"d":"5%"},"50000 तक",null,{"v":0.05,"d":"5%"},{"$f":"ROUND(IF(Master!F11=\"NO\",IF(M37<250001,0,IF(M37>500000,12500,((M37-250000)*0.05))),IF(M37<300001,0,IF(M37>500000,10000,((M37-300000)*0.05)))),0)","v":{"v":12500,"d":"12500.00"}}]
[null,"500001 से 750000 तक",null,null,{"v":0.1,"d":"10%"},"500001 से 750000 तक",null,null,{"v":0.1,"d":"10%"},"500001 से 1000000 तक",null,{"v":0.1,"d":"10%"},{"$f":"ROUND(IF(M37<500001,0,IF(M37>750000,25000,((M37-500000)*0.1))),0)","v":{"v":25000,"d":"25000.00"}}]
[null,"750001 से 1000000 तक",null,null,{"v":0.15,"d":"15%"},"750001 से 1000000 तक",null,null,{"v":0.15,"d":"15%"},"1000001 से अधिक",null,{"v":0.15,"d":"15%"},{"$f":"ROUND(IF(M37<750001,0,IF(M37>1000000,37500,((M37-750000)*0.15))),0)","v":{"v":18293,"d":"18293.00"}}]
[null,"1000001 से 1250000 तक",null,null,{"v":0.2,"d":"20%"},"1000001 से 1250000 तक",null,null,{"v":0.2,"d":"20%"},"1000001 से अधिक",null,{"v":0.2,"d":"20%"},{"$f":"ROUND(IF(M37<1000001,0,IF(M37>1250000,50000,((M37-1000000)*0.2))),0)","v":{"v":0,"d":"0.00"}}]
[null,"1250000 से 1500000 तक",null,null,{"v":0.25,"d":"25%"},"1250000 से 1500000 तक",null,null,{"v":0.25,"d":"25%"},"1000001 से अधिक",null,{"v":0.25,"d":"25%"},{"$f":"ROUND(IF(M37<1250001,0,IF(M37>1500000,62500,((M37-1250000)*0.25))),0)","v":{"v":0,"d":"0.00"}}]
[null,"1500000  से अधिक",null,null,{"v":0.3,"d":"30%"},"1500000  से अधिक",null,null,{"v":0.3,"d":"30%"},"1500000  से अधिक",null,{"v":0.3,"d":"30%"},{"$f":"ROUND(IF(M37<1500001,0,(M37-1500000)*0.3),0)","v":{"v":0,"d":"0.00"}}]
[null,1,"योग आयकर",{"$nulls":9},{"$f":"SUM(M40:M46)","v":{"v":55793,"d":"55793.00"}}]
[null,2,"छूट घारा 87(A) (2.50 लाख से 5 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12500 तक)",{"$nulls":9},{"$f":"IF(M37>500000,0,IF(M47<12501,M47,12500))","v":{"v":0,"d":"0.00"}}]
[null,3,"शेष आयकर (1-2)",{"$nulls":9},{"$f":"M47-M48","v":{"v":55793,"d":"55793.00"}}]
[null,4,"शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%  (योग 4%)",{"$nulls":9},{"$f":"ROUND(M49*0.04,0)","v":{"v":2232,"d":"2232.00"}}]
[null,"कुल आयकर (3+4)",{"$nulls":10},{"$f":"SUM(M49:M50)","v":{"v":58025,"d":"58025.00"}}]
[17,"घटाइये :- राहत धारा 89 के तहत",{"$nulls":10},{"$f":"'Other Ded.'!G17","v":{"v":0,"d":"0.00"}}]
[18,"कुल शेष आयकर",{"$nulls":10},{"$f":"M51-M52","v":{"v":58025,"d":"58025.00"}}]
[19,"आयकर कटौती का विवरण",null,"सितम्बर   2021 तक",null,"अक्टूबर से दिसम्बर 2021 तक",null,"जनवरी 2022",null,"फ़रवरी 2022",null,"टी.डी.एस.","कुल टैक्स कटौती (योग कॉलम 19)"]
[{"$nulls":3},{"$f":"SUM('GA 55 For Print'!$X$7:$X$13)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55 For Print'!$X$14:$X$16)","v":{"v":0,"d":"0.00"}},null,{"$f":"'GA 55 For Print'!$X$17","v":{"v":0,"d":"0.00"}},null,{"$f":"'GA 55 For Print'!$X$18","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM('GA 55 Editable'!$X$19:$X$26)+'Other Ded.'!$G$18","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D55:L55)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(M53>M55,\"Income Tax Payable\",IF(M53<M55,\"Income Tax Refundable\",\"Income Tax No Need\"))","v":"Income Tax Payable"},{"$nulls":11},{"$f":"M53-M55","v":{"v":58025,"d":"58025.00"}}]
[]
["Signature Of Employee",{"$nulls":10},"Signature Of DDO"]