{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Tax Calculator For All Employee","HRA Calculator","HRA Receipt"],"not_rendered":{"images":1,"external_links":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Tax Calculator For All Employee","index":0,"n_rows":106,"n_cols":53,"rows_kept":106,"merged":[[0,2,5,2],[0,3,0,6],[0,7,0,39],[0,40,106,40],[1,3,1,39],[2,3,2,39],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,3,19],[3,20,3,28],[3,29,4,29],[3,30,3,32],[3,33,3,35],[3,36,4,36],[3,38,4,39],[5,30,5,32],[5,41,5,46],[5,47,5,52],[6,2,105,2],[106,3,106,35]]}
[{"$nulls":3},"Prepared By :-",{"$nulls":3},"Ummed Tarad (Teacher-GSSS Raimalwada, Mob.No.-9166973141) (Updated On 09-12-2022)"]
[{"$nulls":3},"Office: Principal, Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur (DDO Code-12572)"]
[{"$nulls":3},"Tax Calculation For All Employee For F.Y. 2022-23 (A.Y. 2023-24)"]
[{"$nulls":3},"Sr. No.","Name Of Employee","Total Income","Standard Deduction","HRA Examption","Examption Uder Home Loan","Examption U/S VI [80 C/80 CCC/ 80CCD(1)] Up To 1.5 Lac","Exapmtion U/S 80 CCD(1B) Up To 50000","Exapmtion U/S 80 D/80 DD/80/ 80DDB ","Exapmtion U/S 80 G","NET TAXABLE INCOME (For Old Tax Regime)","TAX (OLD TAX REGIME)",{"$nulls":5},"TAX (NEW TAX REGIME)",{"$nulls":8},"CHOICE (Old Rate/New Rate)","नव.-2022 के वेतन तक की गई Itax कटौती",null,null,"अग्रिम शेष माह में की जाने वाली Itax कटौती",null,null,"Total Deductable Itax",null,"Payble (P), Refundable (R) Itax"]
[{"$nulls":14},"2.5 Lac to 5 Lac","5 Lac to 10 Lac",">10 Lac","Total","Edu. Cess (4%)","Grand Total","2.5 Lac to 5 Lac","5 Lac to 7.5 Lac","7.5 Lac to 10 Lac","10 Lac to 12.5 Lac","12.5 Lac to 15 Lac",">15 Lac","Total","Edu. Cess (4%)","Grand Total",null,"From Salary","Via Challan","Total",{"$f":"IF(AE4=\"नव.-2022 के वेतन तक की गई Itax कटौती\",\"Dec-22\",0)","v":"Dec-22"},{"$f":"IF(AE4=\"नव.-2022 के वेतन तक की गई Itax कटौती\",\"Jan-23\",0)","v":"Jan-23"},"2023-02-01"]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,10,11,8,9,10,12,13,14,14,15,16,17,18,19,15,16,17,18,19,null,null,20,21,22,23,null,24,null,null,"old",{"$nulls":5},"new"]
[{"$f":"MIN(T7,AC7)","v":22984},{"$f":"IF(A7=0,0,IF(A7<=12500,\"R\",0))","v":0},null,1,null,780000,50000,32000,0,150000,0,0,0,{"$f":"F7-G7-H7-I7-J7-K7-L7-M7","v":548000},{"$f":"IF(N7<250000,0,IF(N7>500000,12500,IF(N7<500000,ROUND((N7-250000)*0.05,0),0)))","v":12500},{"$f":"IF(N7<500000,0,IF(N7>1000000,100000,ROUND((N7-500000)*0.2,0)))","v":9600},{"$f":"IF(N7<1000000,0,ROUND((N7-1000000)*0.3,0))","v":0},{"$f":"IF(F7>0,(O7+P7+Q7),0)","v":22100},{"$f":"ROUND(R7*0.04,0)","v":884},{"$f":"R7+S7","v":22984},{"$f":"IF(F7>500000,12500,0)","v":12500},{"$f":"IF(F7<500000,0,IF(F7>750000,25000,ROUND((F7-500000)*0.1,0)))","v":25000},{"$f":"IF(F7<750000,0,IF(F7>1000000,37500,ROUND((F7-750000)*0.15,0)))","v":4500},{"$f":"IF(F7<1000000,0,IF(F7>1250000,50000,ROUND((F7-1000000)*0.2,0)))","v":0},{"$f":"IF(F7<1250000,0,IF(F7>1500000,62500,ROUND((F7-1250000)*0.25,0)))","v":0},{"$f":"IF(F7<1500000,0,ROUND((F7-1500000)*0.3,0))","v":0},{"$f":"U7+V7+W7+X7+Y7+Z7","v":42000},{"$f":"ROUND(AA7*0.04,0)","v":1680},{"$f":"AA7+AB7","v":43680},{"$f":"IF(T7=0,0,IF(T7>AC7,\"New Regime\",\"Old Regime\"))","v":"Old Regime"},8000,null,{"$f":"AE7+AF7","v":8000},{"$f":"MIN(AP7,AV7)","v":5000},{"$f":"MIN(AQ7,AW7)","v":5000},{"$f":"MIN(AR7,AX7)","v":5000},{"$f":"AH7+AI7+AJ7","v":15000},{"$f":"MIN(T7,AC7)","v":22984},{"$f":"IF(AL7<=12500,-AG7,AL7-(AG7+AK7))","v":-16},{"$f":"IF(AM7=0,0,IF(AM7>0,\"(P)\",\"(R)\"))","v":"(R)"},null,{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T7<=12500,0,IF(AG7>T7,0,ROUNDUP((T7-AG7)/3,-3))))","v":5000},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T7<=12500,0,IF(AG7>T7,0,ROUNDUP((T7-AG7)/3,-3))))","v":5000},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((T7-AG7),-3),IF(T7<=12500,0,IF(AG7>T7,0,ROUNDUP((T7-AG7)/3,-3))))","v":5000},{"$f":"AP7+AQ7+AR7","v":15000},{"$f":"AS7+AE7","v":23000},{"$f":"AT7-T7","v":16},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC7<=12500,0,IF(AG7>AC7,0,ROUNDUP((AC7-AG7)/3,-3))))","v":12000},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC7<=12500,0,IF(AG7>AC7,0,ROUNDUP((AC7-AG7)/3,-3))))","v":12000},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((AC7-AG7),-3),IF(AC7<=12500,0,IF(AG7>AC7,0,ROUNDUP((AC7-AG7)/3,-3))))","v":12000},{"$f":"AV7+AW7+AX7","v":36000},{"$f":"AY7+AE7","v":44000},{"$f":"AZ7-AC7","v":320}]
[{"$f":"MIN(T8,AC8)","v":0},{"$f":"IF(A8=0,0,IF(A8<=12500,\"R\",0))","v":0},null,2,{"$nulls":9},{"$f":"F8-G8-H8-I8-J8-K8-L8-M8","v":0},{"$f":"IF(N8<250000,0,IF(N8>500000,12500,IF(N8<500000,ROUND((N8-250000)*0.05,0),0)))","v":0},{"$f":"IF(N8<500000,0,IF(N8>1000000,100000,ROUND((N8-500000)*0.2,0)))","v":0},{"$f":"IF(N8<1000000,0,ROUND((N8-1000000)*0.3,0))","v":0},{"$f":"IF(F8>0,(O8+P8+Q8),0)","v":0},{"$f":"ROUND(R8*0.04,0)","v":0},{"$f":"R8+S8","v":0},{"$f":"IF(F8>500000,12500,0)","v":0},{"$f":"IF(F8<500000,0,IF(F8>750000,25000,ROUND((F8-500000)*0.1,0)))","v":0},{"$f":"IF(F8<750000,0,IF(F8>1000000,37500,ROUND((F8-750000)*0.15,0)))","v":0},{"$f":"IF(F8<1000000,0,IF(F8>1250000,50000,ROUND((F8-1000000)*0.2,0)))","v":0},{"$f":"IF(F8<1250000,0,IF(F8>1500000,62500,ROUND((F8-1250000)*0.25,0)))","v":0},{"$f":"IF(F8<1500000,0,ROUND((F8-1500000)*0.3,0))","v":0},{"$f":"U8+V8+W8+X8+Y8+Z8","v":0},{"$f":"ROUND(AA8*0.04,0)","v":0},{"$f":"AA8+AB8","v":0},{"$f":"IF(T8=0,0,IF(T8>AC8,\"New Regime\",\"Old Regime\"))","v":0},null,null,{"$f":"AE8+AF8","v":0},{"$f":"MIN(AP8,AV8)","v":0},{"$f":"MIN(AQ8,AW8)","v":0},{"$f":"MIN(AR8,AX8)","v":0},{"$f":"AH8+AI8+AJ8","v":0},{"$f":"MIN(T8,AC8)","v":0},{"$f":"IF(AL8<=12500,-AG8,AL8-(AG8+AK8))","v":0},{"$f":"IF(AM8=0,0,IF(AM8>0,\"(P)\",\"(R)\"))","v":0},null,{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T8<=12500,0,IF(AG8>T8,0,ROUNDUP((T8-AG8)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T8<=12500,0,IF(AG8>T8,0,ROUNDUP((T8-AG8)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((T8-AG8),-3),IF(T8<=12500,0,IF(AG8>T8,0,ROUNDUP((T8-AG8)/3,-3))))","v":0},{"$f":"AP8+AQ8+AR8","v":0},{"$f":"AS8+AE8","v":0},{"$f":"AT8-T8","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC8<=12500,0,IF(AG8>AC8,0,ROUNDUP((AC8-AG8)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC8<=12500,0,IF(AG8>AC8,0,ROUNDUP((AC8-AG8)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((AC8-AG8),-3),IF(AC8<=12500,0,IF(AG8>AC8,0,ROUNDUP((AC8-AG8)/3,-3))))","v":0},{"$f":"AV8+AW8+AX8","v":0},{"$f":"AY8+AE8","v":0},{"$f":"AZ8-AC8","v":0}]
[0,0,null,3,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,4,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,5,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,6,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,7,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,8,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,9,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,10,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,11,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,12,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,13,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,14,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,15,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,16,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,17,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,18,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,19,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,20,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,21,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,22,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,23,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,24,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,25,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,26,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,27,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,28,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,29,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,30,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,31,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,32,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,33,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,34,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,35,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,36,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,37,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,38,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,null,39,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},{"$f":"IF(F46>0,50000,0)","v":0},{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"MIN(T56,AC56)","v":0},0,{"$nulls":4},{"$f":"IF(F56>0,50000,0)","v":0},{"$nulls":6},{"$f":"F56-G56-H56-I56-J56-K56-L56-M56","v":0},{"$f":"IF(N56<250000,0,IF(N56>500000,12500,IF(N56<500000,ROUND((N56-250000)*0.05,0),0)))","v":0},{"$f":"IF(N56<500000,0,IF(N56>1000000,100000,ROUND((N56-500000)*0.2,0)))","v":0},{"$f":"IF(N56<1000000,0,ROUND((N56-1000000)*0.3,0))","v":0},{"$f":"IF(F56>0,(O56+P56+Q56),0)","v":0},{"$f":"ROUND(R56*0.04,0)","v":0},{"$f":"R56+S56","v":0},{"$f":"IF(F56>500000,12500,0)","v":0},{"$f":"IF(F56<500000,0,IF(F56>750000,25000,ROUND((F56-500000)*0.1,0)))","v":0},{"$f":"IF(F56<750000,0,IF(F56>1000000,37500,ROUND((F56-750000)*0.15,0)))","v":0},{"$f":"IF(F56<1000000,0,IF(F56>1250000,50000,ROUND((F56-1000000)*0.2,0)))","v":0},{"$f":"IF(F56<1250000,0,IF(F56>1500000,62500,ROUND((F56-1250000)*0.25,0)))","v":0},{"$f":"IF(F56<1500000,0,ROUND((F56-1500000)*0.3,0))","v":0},{"$f":"U56+V56+W56+X56+Y56+Z56","v":0},{"$f":"ROUND(AA56*0.04,0)","v":0},{"$f":"AA56+AB56","v":0},0,null,null,{"$f":"AE56+AF56","v":0},{"$f":"MIN(AP56,AV56)","v":0},{"$f":"MIN(AQ56,AW56)","v":0},{"$f":"MIN(AR56,AX56)","v":0},{"$f":"AH56+AI56+AJ56","v":0},{"$f":"MIN(T56,AC56)","v":0},0,0,null,{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T56<=12500,0,IF(AG56>T56,0,ROUNDUP((T56-AG56)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T56<=12500,0,IF(AG56>T56,0,ROUNDUP((T56-AG56)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((T56-AG56),-3),IF(T56<=12500,0,IF(AG56>T56,0,ROUNDUP((T56-AG56)/3,-3))))","v":0},{"$f":"AP56+AQ56+AR56","v":0},{"$f":"AS56+AE56","v":0},{"$f":"AT56-T56","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC56<=12500,0,IF(AG56>AC56,0,ROUNDUP((AC56-AG56)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC56<=12500,0,IF(AG56>AC56,0,ROUNDUP((AC56-AG56)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((AC56-AG56),-3),IF(AC56<=12500,0,IF(AG56>AC56,0,ROUNDUP((AC56-AG56)/3,-3))))","v":0},{"$f":"AV56+AW56+AX56","v":0},{"$f":"AY56+AE56","v":0},{"$f":"AZ56-AC56","v":0}]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"MIN(T66,AC66)","v":0},0,{"$nulls":4},{"$f":"IF(F66>0,50000,0)","v":0},{"$nulls":6},{"$f":"F66-G66-H66-I66-J66-K66-L66-M66","v":0},{"$f":"IF(N66<250000,0,IF(N66>500000,12500,IF(N66<500000,ROUND((N66-250000)*0.05,0),0)))","v":0},{"$f":"IF(N66<500000,0,IF(N66>1000000,100000,ROUND((N66-500000)*0.2,0)))","v":0},{"$f":"IF(N66<1000000,0,ROUND((N66-1000000)*0.3,0))","v":0},{"$f":"IF(F66>0,(O66+P66+Q66),0)","v":0},{"$f":"ROUND(R66*0.04,0)","v":0},{"$f":"R66+S66","v":0},{"$f":"IF(F66>500000,12500,0)","v":0},{"$f":"IF(F66<500000,0,IF(F66>750000,25000,ROUND((F66-500000)*0.1,0)))","v":0},{"$f":"IF(F66<750000,0,IF(F66>1000000,37500,ROUND((F66-750000)*0.15,0)))","v":0},{"$f":"IF(F66<1000000,0,IF(F66>1250000,50000,ROUND((F66-1000000)*0.2,0)))","v":0},{"$f":"IF(F66<1250000,0,IF(F66>1500000,62500,ROUND((F66-1250000)*0.25,0)))","v":0},{"$f":"IF(F66<1500000,0,ROUND((F66-1500000)*0.3,0))","v":0},{"$f":"U66+V66+W66+X66+Y66+Z66","v":0},{"$f":"ROUND(AA66*0.04,0)","v":0},{"$f":"AA66+AB66","v":0},0,null,null,{"$f":"AE66+AF66","v":0},{"$f":"MIN(AP66,AV66)","v":0},{"$f":"MIN(AQ66,AW66)","v":0},{"$f":"MIN(AR66,AX66)","v":0},{"$f":"AH66+AI66+AJ66","v":0},{"$f":"MIN(T66,AC66)","v":0},0,0,null,{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T66<=12500,0,IF(AG66>T66,0,ROUNDUP((T66-AG66)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T66<=12500,0,IF(AG66>T66,0,ROUNDUP((T66-AG66)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((T66-AG66),-3),IF(T66<=12500,0,IF(AG66>T66,0,ROUNDUP((T66-AG66)/3,-3))))","v":0},{"$f":"AP66+AQ66+AR66","v":0},{"$f":"AS66+AE66","v":0},{"$f":"AT66-T66","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC66<=12500,0,IF(AG66>AC66,0,ROUNDUP((AC66-AG66)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC66<=12500,0,IF(AG66>AC66,0,ROUNDUP((AC66-AG66)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((AC66-AG66),-3),IF(AC66<=12500,0,IF(AG66>AC66,0,ROUNDUP((AC66-AG66)/3,-3))))","v":0},{"$f":"AV66+AW66+AX66","v":0},{"$f":"AY66+AE66","v":0},{"$f":"AZ66-AC66","v":0}]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,{"$f":"IF(A71=0,0,IF(A71<=12500,\"R\",0))","v":0},{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(T72=0,0,IF(T72>AC72,\"New Regime\",\"Old Regime\"))","v":0},null,null,0,0,0,0,0,0,{"$f":"IF(AL72<=12500,-AG72,AL72-(AG72+AK72))","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"MIN(T96,AC96)","v":0},0,{"$nulls":4},{"$f":"IF(F96>0,50000,0)","v":0},{"$nulls":6},{"$f":"F96-G96-H96-I96-J96-K96-L96-M96","v":0},{"$f":"IF(N96<250000,0,IF(N96>500000,12500,IF(N96<500000,ROUND((N96-250000)*0.05,0),0)))","v":0},{"$f":"IF(N96<500000,0,IF(N96>1000000,100000,ROUND((N96-500000)*0.2,0)))","v":0},{"$f":"IF(N96<1000000,0,ROUND((N96-1000000)*0.3,0))","v":0},{"$f":"IF(F96>0,(O96+P96+Q96),0)","v":0},{"$f":"ROUND(R96*0.04,0)","v":0},{"$f":"R96+S96","v":0},{"$f":"IF(F96>500000,12500,0)","v":0},{"$f":"IF(F96<500000,0,IF(F96>750000,25000,ROUND((F96-500000)*0.1,0)))","v":0},{"$f":"IF(F96<750000,0,IF(F96>1000000,37500,ROUND((F96-750000)*0.15,0)))","v":0},{"$f":"IF(F96<1000000,0,IF(F96>1250000,50000,ROUND((F96-1000000)*0.2,0)))","v":0},{"$f":"IF(F96<1250000,0,IF(F96>1500000,62500,ROUND((F96-1250000)*0.25,0)))","v":0},{"$f":"IF(F96<1500000,0,ROUND((F96-1500000)*0.3,0))","v":0},{"$f":"U96+V96+W96+X96+Y96+Z96","v":0},{"$f":"ROUND(AA96*0.04,0)","v":0},{"$f":"AA96+AB96","v":0},0,null,null,{"$f":"AE96+AF96","v":0},{"$f":"MIN(AP96,AV96)","v":0},{"$f":"MIN(AQ96,AW96)","v":0},{"$f":"MIN(AR96,AX96)","v":0},{"$f":"AH96+AI96+AJ96","v":0},{"$f":"MIN(T96,AC96)","v":0},0,0,null,{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T96<=12500,0,IF(AG96>T96,0,ROUNDUP((T96-AG96)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(T96<=12500,0,IF(AG96>T96,0,ROUNDUP((T96-AG96)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((T96-AG96),-3),IF(T96<=12500,0,IF(AG96>T96,0,ROUNDUP((T96-AG96)/3,-3))))","v":0},{"$f":"AP96+AQ96+AR96","v":0},{"$f":"AS96+AE96","v":0},{"$f":"AT96-T96","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC96<=12500,0,IF(AG96>AC96,0,ROUNDUP((AC96-AG96)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",0,IF(AC96<=12500,0,IF(AG96>AC96,0,ROUNDUP((AC96-AG96)/3,-3))))","v":0},{"$f":"IF($AE$4=\"जन.-2023 के वेतन तक की गई Itax कटौती\",ROUNDUP((AC96-AG96),-3),IF(AC96<=12500,0,IF(AG96>AC96,0,ROUNDUP((AC96-AG96)/3,-3))))","v":0},{"$f":"AV96+AW96+AX96","v":0},{"$f":"AY96+AE96","v":0},{"$f":"AZ96-AC96","v":0}]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]
[0,{"$f":"IF(A106=0,0,IF(A106<=12500,\"R\",0))","v":0},{"$nulls":4},0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"HRA Calculator","index":1,"n_rows":13,"n_cols":17,"rows_kept":13,"merged":[[0,1,13,1],[0,3,0,9],[0,10,13,10],[1,2,1,4],[1,5,10,5],[1,6,1,9],[2,3,2,4],[3,3,3,4],[4,3,4,4],[4,6,6,6],[4,7,5,7],[4,8,5,8],[4,9,6,9],[4,11,6,11],[5,3,5,4],[6,3,6,4],[7,3,7,4],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,11,8,11],[8,3,8,4],[8,13,8,14],[9,3,9,4],[9,6,9,7],[9,8,10,9],[10,3,10,4],[10,6,10,7],[11,2,11,9],[11,13,11,14],[12,2,12,3],[12,6,12,7],[12,8,12,9],[13,2,13,9]]}
[null,null,"Prepared By :-","Ummed Tarad (Teacher-GSSS Raimalwada, Mob.No.-9166973141) "]
[null,null,"Employee Related Details",{"$nulls":3},"HRA Calculation"]
[null,null,"Name of Office:-","Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur",null,null,"Sr. No.","Perticulars","Amount (in Rs.)","Examption Amount (in Rs.)"]
[null,null,"Type of official Location :-","Rural Area",null,null,1,"Actual HRA received",{"$f":"N12","v":{"v":49716,"d":"₹ 49,716"}},{"$f":"I4","v":{"v":49716,"d":"₹ 49,716"}},null,null,"Basic",{"$f":"D8","v":{"v":45100,"d":"₹ 45,100"}},{"$f":"ROUND(N4*103%,-2)","v":{"v":46500,"d":"₹ 46,500"}},null,{"$f":"MIN(J4:J9)","v":{"v":-75510,"d":"-₹ 75,510"}}]
[null,null,"Name of Employee :-","Ummed",null,null,2,"(i) Rent Paid (Per month rent*12 months)",{"$f":"D9*12","v":{"v":0,"d":"₹ 0"}},{"$f":"I5-I7","v":{"v":-75510,"d":"-₹ 75,510"}},null,null,"DA",{"$f":"ROUND(N4*0.34,0)","v":15334},{"$f":"ROUND(O4*0.38,0)","v":17670}]
[null,null,"Designation of Employee :-","Teacher"]
[null,null," Employee's PAN :-","ABCDE1234F",{"$nulls":3},"(ii) 10% of (Basic Pay*12 months)+(D.A.*12 months)",{"$f":"ROUND(N9*10%,0)","v":{"v":75510,"d":"₹ 75,510"}},{"$nulls":3},"Total",{"$f":"N4+N5","v":{"v":60434,"d":"₹ 60,434"}},{"$f":"O4+O5","v":{"v":64170,"d":"₹ 64,170"}}]
[null,null,"Basic Pay (March-2022) :-",{"v":45100,"d":"₹ 45,100"},null,null,3,"50 % of (Basic Pay*12 months)+(D.A.*12 months) For Metro cities (Chennai, Dehli, Mumbai, Kolkata) Or 40 % of (Basic Pay*12 months)+(D.A.*12 months) For Non Metro cities",{"$f":"IF(D4=\"Metro City\",ROUND(I7*5,0),IF(D4=\"Non Metro City\",ROUND(I7*4,0),I7))","v":{"v":75510,"d":"₹ 75,510"}},{"$f":"I8","v":{"v":75510,"d":"₹ 75,510"}},{"$nulls":3},{"$f":"N7*4","v":{"v":241736,"d":"₹ 241,736"}},{"$f":"O7*8","v":{"v":513360,"d":"₹ 513,360"}}]
[null,null,"Rent Pay (Per Month) :-",{"v":0,"d":"₹ 0"},{"$nulls":8},"12 Month's Total",{"$f":"N8+O8","v":{"v":755096,"d":"₹ 755,096"}}]
[null,null,"House Owner's Name :-","XYZ",null,null,"Saction 10(13A) {i.e. Exempt HRA u/s 10(13A)}",null,{"$f":"IF(Q4<0,\"Please enter the proper amount of per month's rent\",Q4)","v":"Please enter the proper amount of per month's rent"},{"$nulls":3},"HRA",{"$f":"IF($D$4=\"Rural Area\",ROUND(N4*0.09,0),ROUND(N4*0.18,0))","v":4059},{"$f":"IF($D$4=\"Rural Area\",ROUND(O4*0.09,0),ROUND(O4*0.18,0))","v":4185}]
[null,null,"House Owner's PAN :-","ZYXWV9876U",null,null,"(Lowest of the three)",{"$nulls":6},{"$f":"N10*4","v":16236},{"$f":"O10*8","v":33480}]
[{"$nulls":12},"12 Month's Total",{"$f":"N11+O11","v":{"v":49716,"d":"₹ 49,716"}}]
[{"$f":"I10","v":"Please enter the proper amount of per month's rent"},null,"Quarterly Receipt Amount :-",null,{"$f":"D9*3","v":{"v":0,"d":"₹ 0"}},null,"Yearly Receipt Amount :-",null,{"$f":"I5","v":{"v":0,"d":"₹ 0"}}]

{"sheet":"HRA Receipt","index":2,"n_rows":71,"n_cols":23,"rows_kept":71,"merged":[[0,0,0,22],[0,23,72,23],[1,0,47,0],[1,2,1,10],[1,11,47,11],[1,12,47,12],[1,14,1,22],[1,24,47,24],[2,1,2,10],[2,13,2,22],[3,1,3,10],[3,13,3,22],[4,1,4,7],[4,8,4,9],[4,13,4,19],[4,20,4,21],[5,1,23,1],[5,3,5,10],[5,13,23,13],[5,15,5,22],[6,3,6,6],[6,7,6,9],[6,15,6,18],[6,19,6,21],[7,3,7,10],[7,15,7,22],[8,2,8,5],[8,6,8,10],[8,14,8,17],[8,18,8,22],[9,2,9,5],[9,6,9,10],[9,14,9,17],[9,18,9,22],[10,2,10,3],[10,4,10,10],[10,14,10,15],[10,16,10,22],[11,2,11,10],[11,14,11,22],[12,3,12,4],[12,5,12,10],[12,15,12,16],[12,17,12,22],[13,2,13,10],[13,14,13,22],[14,3,14,4],[14,5,14,10],[14,15,14,16],[14,17,14,22],[15,2,15,10],[15,14,15,22],[16,2,23,5],[16,6,16,10],[16,14,23,17],[16,18,16,22],[17,6,17,10],[17,18,17,22],[18,6,18,7],[18,8,18,10],[18,18,18,19],[18,20,18,22],[19,6,19,10],[19,18,19,22],[20,6,21,10],[20,18,21,22],[22,6,22,8],[22,9,22,10],[22,18,22,20],[22,21,22,22],[23,6,23,10],[23,18,23,22],[24,1,24,10],[24,13,24,22],[25,2,25,10],[25,14,25,22],[26,1,26,10],[26,13,26,22],[27,1,27,10],[27,13,27,22],[28,1,28,7],[28,8,28,9],[28,13,28,19],[28,20,28,21],[29,1,47,1],[29,3,29,10],[29,13,47,13],[29,15,29,22],[30,3,30,6],[30,7,30,9],[30,15,30,18],[30,19,30,21],[31,3,31,10],[31,15,31,22],[32,2,32,5],[32,6,32,10],[32,14,32,17],[32,18,32,22],[33,2,33,5],[33,6,33,10],[33,14,33,17],[33,18,33,22],[34,2,34,3],[34,4,34,10],[34,14,34,15],[34,16,34,22],[35,2,35,10],[35,14,35,22],[36,3,36,4],[36,5,36,10],[36,15,36,16],[36,17,36,22],[37,2,37,10],[37,14,37,22],[38,3,38,4],[38,5,38,10],[38,15,38,16],[38,17,38,22],[39,2,39,10],[39,14,39,22],[40,2,47,5],[40,6,40,10],[40,14,47,17],[40,18,40,22],[41,6,41,10],[41,18,41,22],[42,6,42,7],[42,8,42,10],[42,18,42,19],[42,20,42,22],[43,6,43,10],[43,18,43,22],[44,6,45,10],[44,18,45,22],[46,6,46,8],[46,9,46,10],[46,18,46,20],[46,21,46,22],[47,6,47,10],[47,18,47,22],[48,0,48,22],[48,24,72,24],[49,0,71,0],[49,2,49,10],[49,11,71,11],[49,12,71,12],[49,14,49,22],[50,1,50,10],[50,13,50,22],[51,1,51,10],[51,13,51,22],[52,1,52,7],[52,8,52,9],[52,13,52,19],[52,20,52,21],[53,1,71,1],[53,3,53,10],[53,13,71,13],[53,15,53,22],[54,3,54,6],[54,7,54,9],[54,15,54,18],[54,19,54,21],[55,3,55,10],[55,15,55,22],[56,2,56,5],[56,6,56,10],[56,14,56,17],[56,18,56,22],[57,2,57,5],[57,6,57,10],[57,14,57,17],[57,18,57,22],[58,2,58,3],[58,4,58,10],[58,14,58,15],[58,16,58,22],[59,2,59,10],[59,14,59,22],[60,3,60,4],[60,5,60,10],[60,15,60,16],[60,17,60,22],[61,2,61,10],[61,14,61,22],[62,3,62,4],[62,5,62,10],[62,15,62,16],[62,17,62,22],[63,2,63,10],[63,14,63,22],[64,2,71,5],[64,6,64,10],[64,14,71,17],[64,18,64,22],[65,6,65,10],[65,18,65,22],[66,6,66,7],[66,8,66,10],[66,18,66,19],[66,20,66,22],[67,6,67,10],[67,18,67,22],[68,6,69,10],[68,18,69,22],[70,6,70,8],[70,9,70,10],[70,18,70,20],[70,21,70,22],[71,6,71,10],[71,18,71,22],[72,0,72,22],[73,0,73,24]]}
[]
[null,1,"RECEIPT OF HOUSE RENT",{"$nulls":10},2,"RECEIPT OF HOUSE RENT"]
[null,"(Under section 1 (13-A) of Income Tax Act)",{"$nulls":11},"(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":8},"Date :-",{"$nulls":11},"Date :-"]
[null,null,"I Owner ",{"$f":"'HRA Calculator'!$D$10","v":"XYZ"},{"$nulls":10},"I Owner ",{"$f":"'HRA Calculator'!$D$10","v":"XYZ"}]
[{"$nulls":3},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$5","v":"Ummed"},null,null,{"$f":"CONCATENATE(\"(\",'HRA Calculator'!$D$6,\")\")","v":"(Teacher)"},{"$nulls":4},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$5","v":"Ummed"},null,null,{"$f":"CONCATENATE(\"(\",'HRA Calculator'!$D$6,\")\")","v":"(Teacher)"}]
[null,null,"Address-",{"$f":"'HRA Calculator'!$D$3","v":"Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur"},{"$nulls":10},"Address-",{"$f":"'HRA Calculator'!$D$3","v":"Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur"}]
[null,null,"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"'HRA Calculator'!$E$13","v":0},{"$nulls":7},"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"'HRA Calculator'!$E$13","v":0}]
[null,null,"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$9","v":0},{"$nulls":7},"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$9","v":0}]
[null,null,"Per Month From :-",null,"1 April, 2022 To 30 June, 2022",{"$nulls":9},"Per Month From :-",null,"1 July, 2022 To 30 Sep., 2022"]
[]
[null,null,"Rs.  =  ",{"$f":"G9","v":0},{"$nulls":10},"Rs.  =  ",{"$f":"G9","v":0}]
[]
[null,null,"Date:-",{"$f":"K5","v":"00:00:00"},{"$nulls":10},"Date:-",{"$f":"K5","v":"00:00:00"}]
[]
[{"$nulls":6},"(Signature of House Owner)",{"$nulls":11},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n",{"$nulls":11},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},"Name-",null,{"$f":"D6","v":"XYZ"},{"$nulls":9},"Name-",null,{"$f":"D6","v":"XYZ"}]
[{"$nulls":6},"ADDRESS",{"$nulls":11},"ADDRESS"]
[{"$nulls":6},{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$P$4","v":0},{"$nulls":11},{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$P$4","v":0}]
[]
[{"$nulls":6},"PAN NUMBER",null,null,{"$f":"'HRA Calculator'!$D$11","v":"ZYXWV9876U"},{"$nulls":8},"PAN NUMBER",null,null,{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$Q$4","v":0}]
[]
[]
[null,3,"RECEIPT OF HOUSE RENT",{"$nulls":10},4,"RECEIPT OF HOUSE RENT"]
[null,"(Under section 1 (13-A) of Income Tax Act)",{"$nulls":11},"(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":8},"Date :-",{"$nulls":11},"Date :-"]
[null,null,"I Owner ",{"$f":"'HRA Calculator'!$D$10","v":"XYZ"},{"$nulls":10},"I Owner ",{"$f":"'HRA Calculator'!$D$10","v":"XYZ"}]
[{"$nulls":3},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$5","v":"Ummed"},null,null,{"$f":"CONCATENATE(\"(\",'HRA Calculator'!$D$6,\")\")","v":"(Teacher)"},{"$nulls":4},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$5","v":"Ummed"},null,null,{"$f":"CONCATENATE(\"(\",'HRA Calculator'!$D$6,\")\")","v":"(Teacher)"}]
[null,null,"Address-",{"$f":"'HRA Calculator'!$D$3","v":"Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur"},{"$nulls":10},"Address-",{"$f":"'HRA Calculator'!$D$3","v":"Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur"}]
[null,null,"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"'HRA Calculator'!$E$13","v":0},{"$nulls":7},"The sum of  (Quarterly) ",{"$nulls":3},{"$f":"'HRA Calculator'!$E$13","v":0}]
[null,null,"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$9","v":0},{"$nulls":7},"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$9","v":0}]
[null,null,"Per Month From :-",null,"1 Oct., 2022 To 31 Dec., 2022",{"$nulls":9},"Per Month From :-",null,"1 Jan., 2023 To 31 March, 2023"]
[]
[null,null,"Rs.  =  ",{"$f":"G33","v":0},{"$nulls":10},"Rs.  =  ",{"$f":"S33","v":0}]
[]
[null,null,"Date:-",{"$f":"K29","v":"00:00:00"},{"$nulls":10},"Date:-",{"$f":"W29","v":"00:00:00"}]
[]
[{"$nulls":6},"(Signature of House Owner)",{"$nulls":11},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n",{"$nulls":11},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},"Name-",null,{"$f":"D30","v":"XYZ"},{"$nulls":9},"Name-",null,{"$f":"P30","v":"XYZ"}]
[{"$nulls":6},"ADDRESS",{"$nulls":11},"ADDRESS"]
[{"$nulls":6},{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$P$4","v":0},{"$nulls":11},{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$P$4","v":0}]
[]
[{"$nulls":6},"PAN NUMBER",null,null,{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$Q$4","v":0},{"$nulls":8},"PAN NUMBER",null,null,{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$Q$4","v":0}]
[]
[]
[null,1,"RECEIPT OF HOUSE RENT",{"$nulls":10},2,"RECEIPT OF HOUSE RENT"]
[null,"(Under section 1 (13-A) of Income Tax Act)",{"$nulls":11},"(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":8},"Date :-",{"$nulls":11},"Date :-"]
[null,null,"I Owner ",{"$f":"'HRA Calculator'!$D$10","v":"XYZ"},{"$nulls":10},"I Owner ",{"$f":"'HRA Calculator'!$D$10","v":"XYZ"}]
[{"$nulls":3},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$5","v":"Ummed"},null,null,{"$f":"CONCATENATE(\"(\",'HRA Calculator'!$D$6,\")\")","v":"(Teacher)"},{"$nulls":4},"Received with Thanks from Sri/Smt. ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$5","v":"Ummed"},null,null,{"$f":"CONCATENATE(\"(\",'HRA Calculator'!$D$6,\")\")","v":"(Teacher)"}]
[null,null,"Address-",{"$f":"'HRA Calculator'!$D$3","v":"Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur"},{"$nulls":10},"Address-",{"$f":"'HRA Calculator'!$D$3","v":"Govt. Sr. Sec. School Raimalwada, Bapini-Jodhpur"}]
[null,null,"The sum of  (Yearly) ",{"$nulls":3},{"$f":"'HRA Calculator'!$I$13","v":0},{"$nulls":7},"The sum of  (Yearly) ",{"$nulls":3},{"$f":"'HRA Calculator'!$I$13","v":0}]
[null,null,"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$9","v":0},{"$nulls":7},"Towards the House Rent (Monthly) @ ",{"$nulls":3},{"$f":"'HRA Calculator'!$D$9","v":0}]
[null,null,"Per Month From :-",null,"1 April, 2022 To 31 March, 2023",{"$nulls":9},"Per Month From :-",null,{"$f":"E59","v":"1 April, 2022 To 31 March, 2023"}]
[]
[null,null,"Rs.  =  ",{"$f":"G57","v":0},{"$nulls":10},"Rs.  =  ",{"$f":"G57","v":0}]
[]
[null,null,"Date:-",{"$f":"K53","v":"00:00:00"},{"$nulls":10},"Date:-",{"$f":"K53","v":"00:00:00"}]
[]
[{"$nulls":6},"(Signature of House Owner)",{"$nulls":11},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n",{"$nulls":11},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},"Name-",null,{"$f":"D54","v":"XYZ"},{"$nulls":9},"Name-",null,{"$f":"D54","v":"XYZ"}]
[{"$nulls":6},"ADDRESS",{"$nulls":11},"ADDRESS"]
[{"$nulls":6},{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$P$4","v":0},{"$nulls":11},{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$P$4","v":0}]
[]
[{"$nulls":6},"PAN NUMBER",null,null,{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$Q$4","v":0},{"$nulls":8},"PAN NUMBER",null,null,{"$f":"'[1]Exemp.(HRA+Other) & Other incom'!$Q$4","v":0}]